java.sql.SQLException: ORA-06550: line 2, column 26: PLS-00302: component 'P_DELIVERY_ID' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by Newton's Apple, 1 year ago
ORA-06550: line 2, column 26: PLS-00302: component 'P_DELIVERY_ID' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored
via Oracle Community by 665465, 1 year ago
ORA-06550: line 3, column 17: PLS-00302: component 'PTRXNUMF' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 4, column 17: PLS-00302: component 'PTRXNUMT' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored
via Stack Overflow by user1344022
, 10 months ago
ORA-06550: line 1, column 7: PLS-00201: identifier 'SCHEMA_RESTORE.RESTORE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
via dolinked.com by Unknown author, 2 years ago
ORA-06550: line 1, column 7: PLS-00201: identifier 'SCHEMA_RESTORE.RESTORE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
via Oracle Community by 843853, 1 year ago
ORA-06550: line 1, column 7: PLS-00221: 'PA_SEARCH_NOTES' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored
via Oracle Community by 441217, 11 months ago
ORA-01403: no data found ORA-06512: at "db.packageA", line 2639 ORA-06512: at line 1
java.sql.SQLException: ORA-06550: line 2, column 26: PLS-00302: component 'P_DELIVERY_ID' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)
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:348)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293)
at oracle.apps.fnd.cp.request.Run.main(Run.java:161)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 6 months ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
30 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.