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
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

    EBS 11i SSO with OAM 10g

    Oracle Community | 5 years ago | User646900-Oracle
    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 | 8 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

    Debug « Middleware Magic

    middlewaremagic.com | 2 years ago
    java.sql.SQLException: Closed Connection
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
    FndSsoLoginProcess2.doGet
    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)
    4. oracle.apps.fnd.ext.common.server.FndSsoLoginProcess2.doGet(FndSsoLoginProcess2.java:172)
    4 frames
  5. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  6. Atmosphere weblogic
    RequestDispatcherImpl.forward
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
    4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
    5. weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:499)
    6. weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:248)
    6 frames
  7. oracle.apps.fnd
    FndSsoLogin.doGet
    1. oracle.apps.fnd.ext.common.server.FndSsoLogin.doPost(FndSsoLogin.java:322)
    2. oracle.apps.fnd.ext.common.server.FndSsoLogin.doGet(FndSsoLogin.java:66)
    2 frames
  8. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  9. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  10. oracle.apps.fnd
    FndSsoFilter.doFilter
    1. oracle.apps.fnd.ext.common.server.FndSsoFilter.doFilter(FndSsoFilter.java:64)
    1 frame
  11. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3588)
    2 frames
  12. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  13. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  14. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2200)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2106)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1428)
    3 frames
  15. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    2 frames