java.sql.SQLException: ORA-06550: line 2, column 22: PLS-00103: Encountered the symbol "." when expecting one of the following: * & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Hi All
    via by 1038522,
  • Error In XML Publisher Data Definition
    via by 3130002,
  • Error in BI Publisher concurrent programs
    via by 3130002,
  • Oracle EBS Report creation
    via by Sardar Nale,
  • DBAT Trusted Reconciliation error
    via by 2752381,
  • EBS R12.2.6 - Create accounting error
    via by Beauty_and_dBest,
  • MyBatis Error Calling Oracle Function
    via Stack Overflow by greyfox
    ,
  • Ghost index calling oracle function
    via Stack Overflow by Alvaro Gomez
    ,
    • java.sql.SQLException: ORA-06550: line 2, column 22: PLS-00103: Encountered the symbol "." when expecting one of the following: * & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539) at oracle.xdo.dataengine.datasource.PlsqlFunctionCall.getRemoteValue(PlsqlFunctionCall.java:165) at oracle.xdo.dataengine.DataHandler.getRemoteValue(DataHandler.java:976) at oracle.xdo.dataengine.DataHandler.getBindValue(DataHandler.java:371)

    Users with the same issue

    balintn
    balintn11 times, last one,
    Cafecanudo
    Cafecanudo2 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    52 more bugmates