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 | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Oracle EBS Report creation

    Oracle Community | 7 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

    Debug « Middleware Magic

    middlewaremagic.com | 2 years ago
    java.sql.SQLException: Closed Connection
  5. 0

    Debug « WebLogic

    middlewaremagic.com | 8 months ago
    java.sql.SQLException: Closed Connection
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