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

Oracle Community | user10719205 | 1 year ago
  1. 0

    Functions/Store Procedures in BI Publisher - failed to load XML

    Oracle Community | 1 year ago | user10719205
    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
  2. 0

    Hi All

    Oracle Community | 3 years ago | 1038522
    java.sql.SQLException: ORA-06550: line 2, column 11: PLS-00302: component 'PM_BRN' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 11: PLS-00302: component 'PM_SBRN' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 4, column 11: PLS-00302: component 'PM_CCY' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored ORA-06550: line 5, column 11: PLS-00302: component 'PM_GLLEVEL' must be declared ORA-06550: line 5, column 1: PL/SQL: Statement ignored ORA-06550: line 6, column 11: PLS-00302: component 'PM_FROM' must be declared ORA-06550: line 6, column 1: PL/SQL: Statement ignored ORA-06550: line 7, column 11: PLS-00302: component 'PM_TO' must be declared ORA-06550: line 7, column 1: PL/SQL: Statement ignored
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 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
  5. 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

  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 22: PLS-00103: Encountered the symbol "." when expecting one of the following: * &amp; = - + ; &lt; / > at in is mod remainder not rem &lt;an exponent (**)> &lt;> or != or ~= >= &lt;= &lt;> and or like like2 like4 likec between || multiset member submultiset

    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.xdo.dataengine
    DataHandler.getBindValue
    1. oracle.xdo.dataengine.datasource.PlsqlFunctionCall.getRemoteValue(PlsqlFunctionCall.java:165)
    2. oracle.xdo.dataengine.DataHandler.getRemoteValue(DataHandler.java:976)
    3. oracle.xdo.dataengine.DataHandler.getBindValue(DataHandler.java:371)
    3 frames