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

Samebug tips1

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web11601

  • 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
  • via Oracle Community by praneeth, 1 year ago
    ORA-06550: line 2, column 12: PLS-00302: component 'P_LOB' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 12: PLS-00302: component 'P_DIV_FROM' must be declared ORA-06550: line 3, column 1: PL/SQL
  • via Oracle Community by 1038522, 11 months ago
    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
  • Stack trace

    • 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 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374) at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:650) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:262) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254) at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390) at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355) at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334) at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294) at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    11 times, 9 months ago
    2 times, 10 months ago
    52 more bugmates