java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Oracle Community | SUDHIR BHILAR | 2 years ago
  1. 0

    Missing IN or OUT parameter at index:: 1

    Oracle Community | 1 year ago | 2712224
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    java.sql.SQLException: Missing IN or OUT parameter

    Oracle Community | 6 years ago | 862119
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  4. 0

    java.sql.SQLException: SQL string is not Query

    Oracle Community | 4 years ago | user10313574
    java.sql.SQLException: SQL string is not Query

  1. qavid 1 times, last 5 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

    Missing IN or OUT parameter at index:: 1

    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1937)
    2. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
    4. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
    4 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
    1 frame
  4. oracle.jbo.server
    OAJboViewObjectImpl.executeQueryForCollection
    1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
    2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
    3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
    4 frames
  5. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4591)
    1 frame
  6. oracle.jbo.server
    ViewObjectImpl.executeQuery
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
    2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
    3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)
    4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)
    5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
    5 frames
  7. oracle.apps.fnd
    OAMessageRatingBarBean.getAttributeValueImpl
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
    2. oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.createListDataObject(OAWebBeanPickListHelper.java:992)
    3. oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getListDataObject(OAWebBeanPickListHelper.java:837)
    4. oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getList(OAWebBeanPickListHelper.java:481)
    5. oracle.apps.fnd.framework.webui.beans.message.OAMessageRatingBarBean.getList(OAMessageRatingBarBean.java:458)
    6. oracle.apps.fnd.framework.webui.OADataBoundValuePickListRequired.getValue(Unknown Source)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1844)
    8. oracle.apps.fnd.framework.webui.beans.message.OAMessageRatingBarBean.getAttributeValueImpl(OAMessageRatingBarBean.java:235)
    8 frames
  8. oracle.cabo.ui
    BaseUINode.getAttributeValue
    1. oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
    1 frame
  9. oracle.apps.fnd
    OATableBean.getAttributeValueImpl
    1. oracle.apps.fnd.framework.webui.OABoundValueColumnHeaderData.getDefaultColumnHeaders(OABoundValueColumnHeaderData.java:320)
    2. oracle.apps.fnd.framework.webui.OABoundValueColumnHeaderData.getValue(OABoundValueColumnHeaderData.java:146)
    3. oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1844)
    4. oracle.apps.fnd.framework.webui.beans.table.OATableBean.getAttributeValueImpl(OATableBean.java:855)
    4 frames
  10. oracle.cabo.ui
    BaseUINode.getAttributeValue
    1. oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
    1 frame
  11. oracle.apps.fnd
    OATableBean.render
    1. oracle.apps.fnd.framework.webui.OATableHelper.processTabularFunction(OATableHelper.java:1601)
    2. oracle.apps.fnd.framework.webui.OATableHelper.prepareColumnFooters(OATableHelper.java:1481)
    3. oracle.apps.fnd.framework.webui.OATableHelper.preRender(OATableHelper.java:2656)
    4. oracle.apps.fnd.framework.webui.beans.table.OATableBean.render(OATableBean.java:638)
    4 frames
  12. oracle.cabo.ui
    BaseUINode.render
    1. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    2. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    3. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source)
    4. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    5. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    6. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    7. oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
    8. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source)
    9. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    10. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    11. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    12. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    13. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    14. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    15. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    16. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    17. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    18. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    19. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    20. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    21. oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source)
    22. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    23. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    24. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    25. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    26. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    27. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    28. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    29. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    30. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    31. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    32. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    33. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source)
    34. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    35. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    36. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    37. oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
    38. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source)
    39. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    40. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    41. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    42. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    43. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    44. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    45. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    46. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    47. oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source)
    48. oracle.cabo.ui.laf.swan.desktop.ContentRenderer.renderContent(Unknown Source)
    49. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    50. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    51. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    52. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    53. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    54. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    55. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    56. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    57. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    58. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    59. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    60. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    61. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    62. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    63. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    64. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    65. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    66. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    67. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    68. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    69. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    70. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    71. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    72. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    73. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    74. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    75. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    76. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    77. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    78. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    79. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    80. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    81. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    82. oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
    83. oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source)
    84. oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.render(Unknown Source)
    85. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    86. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    87. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    88. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    89. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    90. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    91. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    92. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    93. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    94. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    95. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    96. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    97. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    98. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    99. oracle.cabo.ui.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source)
    100. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    101. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    101 frames
  13. oracle.apps.fnd
    OABodyBean.render
    1. oracle.apps.fnd.framework.webui.beans.OABodyBean.render(OABodyBean.java:403)
    1 frame
  14. oracle.cabo.ui
    PartialPageUtils.renderPartialPage
    1. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    2. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    3. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    4. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    5. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    6. oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.renderContent(Unknown Source)
    7. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    8. oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.render(Unknown Source)
    9. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    10. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    11. oracle.cabo.ui.partial.PartialPageUtils.renderPartialPage(Unknown Source)
    11 frames
  15. oracle.apps.fnd
    OAPageBean.renderDocument
    1. oracle.apps.fnd.framework.webui.OAPageBean.render(OAPageBean.java:3833)
    2. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3473)
    3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3237)
    3 frames
  16. _pages
    __oa._jspService
    1. _pages.__oa._jspService(__oa.java:252)
    1 frame
  17. weblogic.servlet.jsp
    JspBase.service
    1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
    1 frame
  18. Atmosphere weblogic
    RequestDispatcherImpl.forward
    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.ServletStubImpl.execute(ServletStubImpl.java:184)
    5. weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
    6. weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)
    6 frames
  19. weblogic.servlet.jsp
    PageContextImpl.forward
    1. weblogic.servlet.jsp.PageContextImpl.forward(PageContextImpl.java:159)
    1 frame
  20. _pages
    __oa._jspService
    1. _pages.__oa._jspService(__oa.java:246)
    1 frame
  21. weblogic.servlet.jsp
    JspBase.service
    1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
    1 frame
  22. 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
  23. oracle.apps.fnd
    WLFilter.doFilter
    1. oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
    1 frame
  24. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  25. oracle.apps.jtf
    JTFWrapperFilter.doFilter
    1. oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
    1 frame
  26. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  27. oracle.apps.jtf
    ReleaseResFilter.doFilter
    1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
    1 frame
  28. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  29. oracle.apps.fnd
    AppsServletFilter.doFilter
    1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
    1 frame
  30. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  31. oracle.security.jps
    JpsAbsFilter$1.run
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    1 frame
  32. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  33. 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
  34. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  35. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
    1 frame
  36. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
    3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
    3 frames
  37. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  38. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  39. 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
  40. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames