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

Oracle Community | 1038522 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 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
  2. 0

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

    Oracle Community | 2 years 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
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Error In XML Publisher Data Definition

    Oracle Community | 1 year 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 | 1 year 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 7 months ago
  2. Cafecanudo 2 times, last 7 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 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

    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
    PlsqlFunctionCall.runPlsql
    1. oracle.xdo.dataengine.datasource.PlsqlFunctionCall.runPlsql(PlsqlFunctionCall.java:95)
    1 frame