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

Samebug tips1

tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web596

  • via by User646900-Oracle,
  • Stack trace

    • 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(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3858) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98) at oracle.apps.fnd.ext.jdbc.utils.QueryRunner.executeCallable(QueryRunner.java:322) at oracle.apps.fnd.ext.jdbc.utils.QueryRunner.executeNoOutCallable(QueryRunner.java:193) at oracle.apps.fnd.ext.sso.SsoUser.updateUserGuid(SsoUser.java:179) at oracle.apps.fnd.ext.common.server.FndSsoLoginProcess2.doGet(FndSsoLoginProcess2.java:172) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175) at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:499) at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:248) at oracle.apps.fnd.ext.common.server.FndSsoLogin.doPost(FndSsoLogin.java:322) at oracle.apps.fnd.ext.common.server.FndSsoLogin.doGet(FndSsoLogin.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.apps.fnd.ext.common.server.FndSsoFilter.doFilter(FndSsoFilter.java:64) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3588) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2200) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2106) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1428) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    balintnbalintn
    11 times, last one,
    CafecanudoCafecanudo
    2 times, last one,
    99 more bugmates