java.sql.SQLException

ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set specification> <an alternatively

Samebug tips1

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

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web17587

  • via Oracle Community by Sardar Nale, 11 months ago
    ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min
  • via Oracle Community by user12003776, 1 year ago
    ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min
  • via Oracle Community by 3130002, 11 months ago
    ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min
  • Stack trace

    • java.sql.SQLException: ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set specification> <an alternatively 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.apps.xdo.dataengine.DataTemplateParser.getRemoteValue(Unknown Source) at oracle.apps.xdo.dataengine.DataTemplateParser.getBindValue(Unknown Source) at oracle.apps.xdo.dataengine.XMLPGEN.setDSBindVariables(Unknown Source) at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(Unknown Source) at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(Unknown Source) at oracle.apps.xdo.dataengine.XMLPGEN.writeData(Unknown Source) at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(Unknown Source) at oracle.apps.xdo.dataengine.XMLPGEN.processData(Unknown Source) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(Unknown Source) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(Unknown Source) at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(Unknown Source) at oracle.apps.xdo.dataengine.DataProcessor.processData(Unknown Source) at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334) at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294) at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

    Write tip

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

    Users with the same issue

    Unknown user
    Once, 1 year ago
    11 times, 9 months ago
    2 times, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    52 more bugmates