java.lang.RuntimeException: java.sql.SQLException: ORA-06550: line 1, column 310: PLS-00302: component 'ADD_USER_TO_OID_SUB_LIST' must be declared ORA-06550: line 1, column 297: PL/SQL: Statement ignored

Oracle Community | User646900-Oracle | 5 years ago
  1. 0

    EBS 11i SSO with OAM 10g

    Oracle Community | 5 years ago | User646900-Oracle
    java.lang.RuntimeException: java.sql.SQLException: ORA-06550: line 1, column 310: PLS-00302: component 'ADD_USER_TO_OID_SUB_LIST' must be declared ORA-06550: line 1, column 297: PL/SQL: Statement ignored
  2. 0

    Starting WLS_Spaces throws error identifier 'MDS_INTERNAL_SHREDDED.GETREPOS

    Oracle Community | 7 years ago | 713769
    oracle.mds.lcm.exception.MDSLCMException: ORA-06550: line 1, column 12: PLS-00201: identifier 'MDS_INTERNAL_SHREDDED.GETREPOSITORYVERSION' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  3. 0

    I cannot test simple example HelloWorld BPEL Process using WebLogic Server

    Oracle Community | 7 years ago | Obada
    java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQUEUE_OAOO_DELIVERY'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Issues while starting soa_server1

    Oracle Community | 7 years ago | 737342
    java.sql.SQLException: ORA-06576: not a valid function or procedure name
  6. 0

    Debugging Basic JDBC Issues « WebLogic

    middlewaremagic.com | 3 days ago
    java.sql.SQLException: Closed Connection

  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 1, column 310: PLS-00302: component 'ADD_USER_TO_OID_SUB_LIST' must be declared ORA-06550: line 1, column 297: PL/SQL: Statement ignored

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    7. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
    8. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
    12. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3858)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    13 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.execute
    1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98)
    1 frame
  4. oracle.apps.fnd
    SsoUser.updateUserGuid
    1. oracle.apps.fnd.ext.jdbc.utils.QueryRunner.executeCallable(QueryRunner.java:322)
    2. oracle.apps.fnd.ext.jdbc.utils.QueryRunner.executeNoOutCallable(QueryRunner.java:193)
    3. oracle.apps.fnd.ext.sso.SsoUser.updateUserGuid(SsoUser.java:179)
    3 frames