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

Oracle Community | User544872 | 3 years ago
  1. 0

    Running seeded OAF page in JDeveloper

    Oracle Community | 3 years ago | User544872
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  2. 0

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

    Oracle Community | 7 years ago | 433324
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  3. 0

    how to dynamic pass values to LOV

    Oracle Community | 7 years ago | 713492
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: Missing IN or OUT parame... | Oracle Community

    oracle.com | 11 months ago
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1

    12 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.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
      3. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1566)
      4. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2996)
      5. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
      5 frames
    3. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:857)
      2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:666)
      3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3655)
      4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      4 frames
    4. oracle.apps.fnd
      OAViewObjectImpl.executeQueryForCollection
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(Unknown Source)
      1 frame
    5. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)
      2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:891)
      3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:805)
      4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:799)
      5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3575)
      5 frames
    6. oracle.apps.fnd
      OAMessageChoiceBean.getAttributeValueImpl
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.createListDataObject(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getListDataObject(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getList(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getList(Unknown Source)
      6. oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getList(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OADataBoundValuePickListData.getValue(Unknown Source)
      8. oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(Unknown Source)
      9. oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(Unknown Source)
      9 frames
    7. oracle.cabo.ui
      BaseUINode.getAttributeValue
      1. oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
      1 frame
    8. oracle.apps.fnd
      OAMessageChoiceBean.getAttributeValueImpl
      1. oracle.apps.fnd.framework.webui.OADataBoundValuePickListSelectionIndex.getValue(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(Unknown Source)
      3. oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(Unknown Source)
      3 frames
    9. oracle.cabo.ui
      XhtmlLafRenderer.render
      1. oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
      2. oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source)
      3. oracle.cabo.ui.collection.AttributeMapProxy.getAttribute(Unknown Source)
      4. oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source)
      5. oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
      6. oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source)
      7. oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source)
      8. oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
      9. oracle.cabo.ui.laf.base.BaseLafUtils.getLocalAttribute(Unknown Source)
      10. oracle.cabo.ui.laf.base.xhtml.OptionContainerRenderer.getSelectedIndex(Unknown Source)
      11. oracle.cabo.ui.laf.base.xhtml.OptionContainerRenderer.populateOptionInfo(Unknown Source)
      12. oracle.cabo.ui.laf.base.xhtml.OptionContainerRenderer.createOptionInfo(Unknown Source)
      13. oracle.cabo.ui.laf.base.xhtml.OptionContainerRenderer.prerender(Unknown Source)
      14. oracle.cabo.ui.laf.base.xhtml.ChoiceRenderer.prerender(Unknown Source)
      15. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      16. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      17. oracle.cabo.ui.laf.base.xhtml.FormElementRenderer.render(Unknown Source)
      18. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      19. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      20. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      21. oracle.cabo.ui.BaseRenderer.renderNamedChild(Unknown Source)
      22. oracle.cabo.ui.laf.base.SwitcherRenderer._renderCase(Unknown Source)
      23. oracle.cabo.ui.laf.base.SwitcherRenderer.renderContent(Unknown Source)
      24. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      25. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      26. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      27. oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
      28. oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source)
      29. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      30. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      31. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      32. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      33. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      34. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      35. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      36. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      37. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      38. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      39. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      40. oracle.cabo.ui.laf.base.xhtml.RowLayoutRenderer.renderChild(Unknown Source)
      41. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      42. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      43. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      44. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      45. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      46. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      47. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      48. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      49. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      50. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      51. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      52. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      53. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      54. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      55. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      56. oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
      57. oracle.cabo.ui.laf.base.xhtml.InlineMessageRenderer.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.laf.base.xhtml.RowLayoutRenderer.renderChild(Unknown Source)
      62. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      63. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      64. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      65. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      66. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      67. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      68. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      69. oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source)
      70. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      71. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      72. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      73. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      74. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      75. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      76. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      77. oracle.cabo.ui.composite.ContextPropertyUINode$Rndr.render(Unknown Source)
      78. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      79. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      80. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      81. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      82. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      83. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      84. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      85. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      86. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      87. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      88. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      89. oracle.cabo.ui.laf.base.xhtml.RowLayoutRenderer.renderChild(Unknown Source)
      90. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      91. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      92. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      93. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      94. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      95. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      96. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      97. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      98. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      99. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      100. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      101. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      102. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      103. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      104. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      105. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      106. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source)
      107. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      108. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      109. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      110. oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
      111. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source)
      112. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      113. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      113 frames