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

Oracle Community | Newton's Apple | 6 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

    AfterReport trigger is not getting called - Need Help

    Oracle Community | 6 years ago | Newton's Apple
    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
  2. 0

    Problem in Data Template ORA-00911: invalid character

    Oracle Community | 8 years ago | 665465
    java.sql.SQLException: 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
  3. 0

    data template datatrigger error

    Oracle Community | 8 years ago | 662435
    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> 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-quoted S
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: ORA-01008: not all variables bound using Mybatis 3

    Stack Overflow | 3 years ago | Raitei
    java.sql.SQLException: ORA-01008: not all variables bound
  6. 0

    JDBC with BLOB

    Oracle Community | 1 decade ago | 326747
    java.sql.SQLException: ORA-01465: invalid hex number

  1. rp 1 times, last 4 months ago
26 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 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()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.execute
    1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
    2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
    3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
    5. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)
    5 frames
  5. 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:348)
    8. oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293)
    8 frames
  6. oracle.apps.fnd
    Run.main
    1. oracle.apps.fnd.cp.request.Run.main(Run.java:161)
    1 frame