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