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

Oracle Community | 3130002 | 11 months ago
  1. 0

    Error In XML Publisher Data Definition

    Oracle Community | 11 months ago | 3130002
    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
  2. 0

    Error in BI Publisher concurrent programs

    Oracle Community | 11 months ago | 3130002
    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
  3. 0

    [052111_121233777][EXCEPTION] SQLException encounter while executing data

    Oracle Community | 6 years ago | oracle_developer
    java.sql.SQLException: ORA-06550: line 2, column 36: PLS-00302: component 'P_LOCAL_LEDGER' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 36: PLS-00302: component 'P_PERIODE' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    xml ERROR

    Oracle Community | 5 years ago | 927548
    java.sql.SQLException: ORA-06550: line 2, column 22: PLS-00302: component 'P_MODULE' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 22: PLS-00302: component 'P_STATUS' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 4, column 22: PLS-00302: component 'P_ITEM_ID' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored
  6. 0

    ava.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character

    Oracle Community | 5 years ago | EBSDBA
    java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.WSH_WSHRDXCP_XMLP_PKG", line 239 ORA-06512: at line 4at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

  1. balintn 11 times, last 2 months ago
  2. Cafecanudo 2 times, last 3 months ago
18 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
    8. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
    12. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
    13 frames
  3. oracle.apps.xdo
    JCP4XDODataEngine.runProgram
    1. oracle.apps.xdo.dataengine.DataTemplateParser.getRemoteValue(Unknown Source)
    2. oracle.apps.xdo.dataengine.DataTemplateParser.getBindValue(Unknown Source)
    3. oracle.apps.xdo.dataengine.XMLPGEN.setDSBindVariables(Unknown Source)
    4. oracle.apps.xdo.dataengine.XMLPGEN.processQuery(Unknown Source)
    5. oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(Unknown Source)
    6. oracle.apps.xdo.dataengine.XMLPGEN.writeData(Unknown Source)
    7. oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(Unknown Source)
    8. oracle.apps.xdo.dataengine.XMLPGEN.processData(Unknown Source)
    9. oracle.apps.xdo.dataengine.XMLPGEN.processXML(Unknown Source)
    10. oracle.apps.xdo.dataengine.XMLPGEN.writeXML(Unknown Source)
    11. oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(Unknown Source)
    12. oracle.apps.xdo.dataengine.DataProcessor.processData(Unknown Source)
    13. oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
    14. oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
    14 frames
  4. oracle.apps.fnd
    Run.main
    1. oracle.apps.fnd.cp.request.Run.main(Run.java:156)
    1 frame