oracle.xdo.XDOException: oracle.xdo.XDOException: 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
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Hi All

    Oracle Community | 3 years ago | 1038522
    oracle.xdo.XDOException: oracle.xdo.XDOException: 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

    Root Cause Analysis

    1. oracle.xdo.XDOException

      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.xdo.dataengine.datasource.PlsqlFunctionCall.runPlsql()
    2. oracle.xdo.dataengine
      DBTriggerEvent.evaluate
      1. oracle.xdo.dataengine.datasource.PlsqlFunctionCall.runPlsql(PlsqlFunctionCall.java:107)
      2. oracle.xdo.dataengine.datasource.PlsqlFunctionCall.runPlsql(PlsqlFunctionCall.java:43)
      3. oracle.xdo.dataengine.DBTriggerEvent.evaluate(DBTriggerEvent.java:42)
      3 frames