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

Oracle Community | Sardar Nale | 5 months ago
  1. 0

    Oracle EBS Report creation

    Oracle Community | 5 months ago | Sardar Nale
    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
  2. 0

    DBAT Trusted Reconciliation error

    Oracle Community | 2 years ago | 2752381
    oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00905: object DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Debugging Basic JDBC Issues « WebLogic

    middlewaremagic.com | 1 week ago
    java.sql.SQLException: Closed Connection
  5. 0

    Debug « Middleware Magic

    middlewaremagic.com | 1 year 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 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

    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. weblogic.jdbc.wrapper
    PreparedStatement.execute
    1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
    1 frame
  4. oracle.apps.xdo
    DataProcessor.processData
    1. oracle.apps.xdo.dataengine.DataTemplateParser.getRemoteValue(Unknown Source)
    2. oracle.apps.xdo.dataengine.DataTemplateParser.getBindValue(Unknown Source)
    3. oracle.apps.xdo.dataengine.XMLPGEN.setDSBindVariables(Unknown Source)
    4. oracle.apps.xdo.dataengine.XMLPGEN.processQuery(Unknown Source)
    5. oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(Unknown Source)
    6. oracle.apps.xdo.dataengine.XMLPGEN.writeData(Unknown Source)
    7. oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(Unknown Source)
    8. oracle.apps.xdo.dataengine.XMLPGEN.processData(Unknown Source)
    9. oracle.apps.xdo.dataengine.XMLPGEN.processXML(Unknown Source)
    10. oracle.apps.xdo.dataengine.XMLPGEN.writeXML(Unknown Source)
    11. oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(Unknown Source)
    12. oracle.apps.xdo.dataengine.DataProcessor.processData(Unknown Source)
    12 frames
  5. com.jdsu.qe
    QuoteAppModuleImpl.printQuote
    1. com.jdsu.qe.quote.model.services.QuoteAppModuleImpl.printQuote(QuoteAppModuleImpl.java:2155)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor2004.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:606)
    3 frames
  7. oracle.adf.model
    DCInvokeMethod.callMethod
    1. oracle.adf.model.binding.DCInvokeMethod.invokeMethod(DCInvokeMethod.java:657)
    2. oracle.adf.model.binding.DCDataControl.invokeMethod(DCDataControl.java:2143)
    3. oracle.adf.model.bc4j.DCJboDataControl.invokeMethod(DCJboDataControl.java:3114)
    4. oracle.adf.model.binding.DCInvokeMethod.callMethod(DCInvokeMethod.java:261)
    4 frames
  8. oracle.jbo.uicli
    JUCtrlActionBinding.doIt
    1. oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1635)
    1 frame
  9. oracle.adf.model
    DCDataControl.invokeOperation
    1. oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2150)
    1 frame
  10. oracle.jbo.uicli
    JUCtrlActionBinding.invoke
    1. oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:740)
    1 frame
  11. oracle.adf.controller
    PageLifecycleImpl.executeEvent
    1. oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.executeEvent(PageLifecycleImpl.java:402)
    1 frame
  12. oracle.adfinternal.view
    FacesCtrlActionBinding.execute
    1. oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding._execute(FacesCtrlActionBinding.java:252)
    2. oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding.execute(FacesCtrlActionBinding.java:210)
    2 frames
  13. com.portal.common
    ADFUtils.executeAction
    1. com.portal.common.fwk.utils.ADFUtils.executeAction(ADFUtils.java:1093)
    2. com.portal.common.fwk.utils.ADFUtils.executeAction(ADFUtils.java:1111)
    2 frames
  14. com.jdsu.qe
    QuoteDetailsBean.onPrint
    1. com.jdsu.qe.quote.view.managed.quotedetails.QuoteDetailsBean.onPrint(QuoteDetailsBean.java:751)
    1 frame
  15. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor2003.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:606)
    3 frames
  16. EL
    MethodExpressionImpl.invoke
    1. com.sun.el.parser.AstValue.invoke(AstValue.java:187)
    2. com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
    2 frames
  17. org.apache.myfaces
    MethodExpressionMethodBinding.invoke
    1. org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)
    1 frame
  18. Apache MyFaces Trinidad API
    UIXCommand.broadcast
    1. org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodBinding(UIXComponentBase.java:1256)
    2. org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:183)
    2 frames
  19. oracle.adf.view
    UIXInclude.broadcast
    1. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:92)
    2. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:361)
    3. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:96)
    4. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:102)
    5. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:92)
    6. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:361)
    7. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:96)
    8. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:96)
    8 frames
  20. JavaEE 7
    UIViewRoot.processApplication
    1. javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475)
    2. javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756)
    2 frames
  21. oracle.adfinternal.view
    LifecycleImpl.execute
    1. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:889)
    2. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:379)
    3. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:194)
    3 frames
  22. JavaEE 7
    FacesServlet.service
    1. javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
    1 frame
  23. 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:301)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    5 frames
  24. oracle.adf.model
    ADFBindingFilter.doFilter
    1. oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:205)
    1 frame
  25. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  26. oracle.adfinternal.view
    RegistrationFilter.doFilter
    1. oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:106)
    1 frame
  27. org.apache.myfaces
    TrinidadFilterImpl$FilterListChain.doFilter
    1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
    1 frame
  28. oracle.adfinternal.view
    AdsFilter.doFilter
    1. oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
    1 frame
  29. org.apache.myfaces
    TrinidadFilterImpl.doFilter
    1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
    2. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)
    3. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)
    3 frames
  30. Apache MyFaces Trinidad API
    TrinidadFilter.doFilter
    1. org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
    1 frame
  31. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  32. oracle.security.wls
    SSOSessionSynchronizationFilter.doFilter
    1. oracle.security.wls.filter.SSOSessionSynchronizationFilter.doFilter(SSOSessionSynchronizationFilter.java:291)
    1 frame
  33. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  34. oracle.adf.library
    LibraryFilter.doFilter
    1. oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:179)
    1 frame
  35. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  36. oracle.security.jps
    JpsAbsFilter$1.run
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    1 frame
  37. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  38. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
    2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
    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
  39. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  40. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
    1 frame
  41. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
    3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
    5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
    5 frames
  42. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  43. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  44. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
    3 frames
  45. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames