java.sql.SQLException: ORA-06550: line 2, column 11: PLS-00302: component 'PM_BRN' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 11: PLS-00302: component 'PM_SBRN' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 4, column 11: PLS-00302: component 'PM_CCY' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored ORA-06550: line 5, column 11: PLS-00302: component 'PM_GLLEVEL' must be declared ORA-06550: line 5, column 1: PL/SQL: Statement ignored ORA-06550: line 6, column 11: PLS-00302: component 'PM_FROM' must be declared ORA-06550: line 6, column 1: PL/SQL: Statement ignored ORA-06550: line 7, column 11: PLS-00302: component 'PM_TO' must be declared ORA-06550: line 7, column 1: PL/SQL: Statement ignored

Oracle Community | 1038522 | 3 years ago
  1. 0

    Hi All

    Oracle Community | 3 years ago | 1038522
    java.sql.SQLException: ORA-06550: line 2, column 11: PLS-00302: component 'PM_BRN' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 11: PLS-00302: component 'PM_SBRN' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 4, column 11: PLS-00302: component 'PM_CCY' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored ORA-06550: line 5, column 11: PLS-00302: component 'PM_GLLEVEL' must be declared ORA-06550: line 5, column 1: PL/SQL: Statement ignored ORA-06550: line 6, column 11: PLS-00302: component 'PM_FROM' must be declared ORA-06550: line 6, column 1: PL/SQL: Statement ignored ORA-06550: line 7, column 11: PLS-00302: component 'PM_TO' must be declared ORA-06550: line 7, column 1: PL/SQL: Statement ignored
  2. 0

    Functions/Store Procedures in BI Publisher - failed to load XML

    Oracle Community | 1 year ago | user10719205
    java.sql.SQLException: ORA-06550: line 2, column 22: PLS-00103: Encountered the symbol "." when expecting one of the following: * & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Error In XML Publisher Data Definition

    Oracle Community | 11 months ago | 3130002
    java.sql.SQLException: ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set specification> <an alternatively
  5. 0

    Error in BI Publisher concurrent programs

    Oracle Community | 11 months ago | 3130002
    java.sql.SQLException: ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set specification> <an alternatively

  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 2, column 11: PLS-00302: component 'PM_BRN' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 11: PLS-00302: component 'PM_SBRN' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 4, column 11: PLS-00302: component 'PM_CCY' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored ORA-06550: line 5, column 11: PLS-00302: component 'PM_GLLEVEL' must be declared ORA-06550: line 5, column 1: PL/SQL: Statement ignored ORA-06550: line 6, column 11: PLS-00302: component 'PM_FROM' must be declared ORA-06550: line 6, column 1: PL/SQL: Statement ignored ORA-06550: line 7, column 11: PLS-00302: component 'PM_TO' must be declared ORA-06550: line 7, column 1: PL/SQL: Statement ignored

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
    8. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
    12. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
    13 frames
  3. oracle.xdo.dataengine
    DataProcessor.processData
    1. oracle.xdo.dataengine.datasource.PlsqlFunctionCall.runPlsql(PlsqlFunctionCall.java:95)
    2. oracle.xdo.dataengine.datasource.PlsqlFunctionCall.runPlsql(PlsqlFunctionCall.java:43)
    3. oracle.xdo.dataengine.DBTriggerEvent.evaluate(DBTriggerEvent.java:42)
    4. oracle.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:575)
    5. oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1333)
    6. oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:376)
    6 frames
  4. oracle.xdo.servlet
    XDOServlet.doGet
    1. oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:318)
    2. oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:672)
    3. oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:290)
    4. oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:346)
    5. oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)
    6. oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1113)
    7. oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:649)
    8. oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:492)
    9. oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:462)
    10. oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:261)
    10 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
    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:300)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  7. oracle.xdo.servlet
    MostRecentFilter.doFilter
    1. oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
    1 frame
  8. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  9. oracle.xdo.servlet
    SecurityFilter.doFilter
    1. oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:124)
    1 frame
  10. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  11. oracle.xdo.servlet
    InitCheckingFilter.doFilter
    1. oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
    1 frame
  12. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  13. oracle.security.jps
    JpsAbsFilter$1.run
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    1 frame
  14. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  15. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
    2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
    3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
    4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
    5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    5 frames
  16. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  17. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
    1 frame
  18. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
    3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
    5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
    5 frames
  19. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  20. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  21. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
    3 frames
  22. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
    2 frames