java.sql.SQLException: ORA-04063: package body "DEV_OIM.OIM_BLKLD_PKG_USR" has errors ORA-06508: PL/SQL: could not find program unit being called: "DEV_OIM.OIM_BLKLD_PKG_USR" ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

Oracle Community | user618384 | 4 years ago
  1. 0

    OIM_BLKLD_PKG_USR invalid

    Oracle Community | 4 years ago | user618384
    java.sql.SQLException: ORA-04063: package body "DEV_OIM.OIM_BLKLD_PKG_USR" has errors ORA-06508: PL/SQL: could not find program unit being called: "DEV_OIM.OIM_BLKLD_PKG_USR" ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  2. 0

    oim bulkload error using database table

    Oracle Community | 4 years ago | 975120
    java.sql.SQLException: ORA-02298: cannot validate (DEV_OIM.FK_USR_ACT) - parent keys not found ORA-06512: at "DEV_OIM.OIM_ENABLE_FKEYCONSTRAINT", line 56 ORA-06512: at "DEV_OIM.OIM_BLKLD_PKG_USR", line 1665 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  3. 0

    error running bulk utility oim11g R!

    Oracle Community | 4 years ago | DianaOrd
    java.sql.SQLException: ORA-00922: missing or invalid option ORA-06512: at "IDM_OIM.OIM_BLKLD_PKG_USR", line 324 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Which sqlType of registerOutParameter should be set when the return value of procedure of oralce is %rowtype?

    Stack Overflow | 2 years ago | yDQ
    java.sql.SQLException: ORA-06550 PL/SQL: Statement ignored</p> <pre><code>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  6. 0

    Ghost index calling oracle function

    Stack Overflow | 3 years ago | Alvaro Gomez
    java.sql.SQLException: Falta el parámetro IN o OUT en el índice:: 2

  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-04063: package body "DEV_OIM.OIM_BLKLD_PKG_USR" has errors ORA-06508: PL/SQL: could not find program unit being called: "DEV_OIM.OIM_BLKLD_PKG_USR" ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    2. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    3. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    4. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    5. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1034)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4694)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1088)
    12 frames
  3. bulkload
    UserLoad.main
    1. bulkload.UserLoad.createTmpExTable(UserLoad.java:512)
    2. bulkload.UserLoad.inputCSV(UserLoad.java:140)
    3. bulkload.UserLoad.showSubMenu(UserLoad.java:95)
    4. bulkload.UserLoad.main(UserLoad.java:983)
    4 frames