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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

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

Solutions on the web

via Oracle Community by 657953, 4 months ago
ORA-31600: invalid input value 0 for parameter STORAGE in function SET_TRANSFORM_PARAM ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-06512: at "SYS.DBMS_METADATA_INT", line 8423 ORA-06512: at "SYS.DBMS_METADATA_INT", line 9483 ORA-06512: at "SYS.DBMS_METADATA", line 3961 ORA-06512: at line 1
via Oracle Community by 567684, 1 year ago
ORA-01704: 字符串文字太长 ORA-06512: 在 "GUANGDONGEARTHQUAKE.FINEWAY_METADATA", line 163 ORA-06512: 在 line 1
via Oracle Community by anammari, 1 year ago
ORA-20000: Oracle Text error: DRG-11130: no data found in the collection ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.DRVODM", line 509 ORA-06512: at line 15
via Oracle Community by User8024990-Oracle, 1 year ago
ORA-06575: Package or function EDN_DEQUEUE_OAOO_DELIVERY is in an invalid state
via Oracle Community by User8024990-Oracle, 1 year ago
ORA-06575: Package or function EDN_DEQUEUE_OAOO_DELIVERY is in an invalid state
via Oracle Community by oracle_developer, 1 year ago
ORA-06550: line 2, column 36: PLS-00302: component 'P_LOCAL_LEDGER' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 36: PLS-00302: component 'P_PERIODE' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored
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 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 oracle.apps.fnd.ext.common.server.FndSsoFilter.doFilter(FndSsoFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.