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

Oracle Community | 927548 | 5 years ago
  1. 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
  2. 0

    [032116_085002634][][EXCEPTION] SQLException encounter while executing data trigger

    Oracle Community | 8 months ago | user10869897
    java.sql.SQLException: ORA-06550: line 2, column 28: PLS-00302: component 'P_CHECKRUN_NAME' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 28: PLS-00302: component 'P_START_DATE' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 4, column 28: PLS-00302: component 'P_END_DATE' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored ORA-06550: line 5, column 28: PLS-00302: component 'P_EMAIL_ID' must be declared ORA-06550: line 5, column 1: PL/SQL: Statement ignored
  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

    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)
  6. 0

    Significance of FND_JDBC_PLSQL_RESET

    Oracle Community | 5 years ago | user10088255
    java.sql.SQLException: ORA-20101: ORA-06512: at "APPS.XXAP_APXINAGE_XMLP_PKG", line 302 ORA-06512: at line 4at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

  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-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

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    7. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
    8. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
    12. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    13 frames
  3. oracle.apps.xdo
    JCP4XDODataEngine.runProgram
    1. oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:650)
    2. oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:262)
    3. oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
    4. oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
    5. oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
    6. oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
    7. oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
    8. oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
    8 frames
  4. oracle.apps.fnd
    Run.main
    1. oracle.apps.fnd.cp.request.Run.main(Run.java:157)
    1 frame