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

Oracle Community | user11258661 | 5 years ago
  1. 0

    SQL error during statement preparation

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

    issue addding custom fields(from custom table)

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

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

    Oracle Community | 7 years ago | 745019
    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

    how to create a transient attribute in a VO in r12

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

    Standard Class code fails if we extend the Class

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

  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:1752)
    2. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
    4. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    4 frames
  3. 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:3723)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
    4 frames
  4. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
    1 frame
  5. oracle.jbo.server
    ViewObjectImpl.executeQuery
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
    2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
    3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
    4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
    5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643)
    5 frames
  6. oracle.apps.fnd
    OAMessageChoiceBean.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.OAWebBeanPickListHelper.getList(OAWebBeanPickListHelper.java:404)
    6. oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getList(OAMessageChoiceBean.java:762)
    7. oracle.apps.fnd.framework.webui.OADataBoundValuePickListData.getValue(OADataBoundValuePickListData.java:86)
    8. oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1809)
    9. oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(OAMessageChoiceBean.java:369)
    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(OADataBoundValuePickListSelectionIndex.java:61)
    2. oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1809)
    3. oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(OAMessageChoiceBean.java:369)
    3 frames
  9. oracle.cabo.ui
    BaseUINode.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.swan.desktop.HeaderRenderer.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.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
    66. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source)
    67. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    68. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    69. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    70. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    71. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    72. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.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.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
    77. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.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.BaseRenderer.renderChild(Unknown Source)
    83. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    84. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    85. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    86. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    87. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    88. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    89. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    90. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    91. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    92. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    93. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    94. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    95. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    96. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    97. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    98. oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source)
    99. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    100. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    101. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    102. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    103. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    104. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    105. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    106. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    107. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    108. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    109. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    110. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source)
    111. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    112. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    113. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    114. oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
    115. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source)
    116. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    117. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    118. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    119. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    120. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    121. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    122. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    123. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    124. oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source)
    125. oracle.cabo.ui.laf.swan.desktop.ContentRenderer.renderContent(Unknown Source)
    126. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    127. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    128. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    129. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    130. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    131. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    132. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    133. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    134. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    135. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    136. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    137. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    138. oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
    139. oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source)
    140. oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.render(Unknown Source)
    141. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    142. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    143. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    144. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    145. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    146. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    147. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    148. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    149. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    150. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    151. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    152. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    153. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    154. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    155. oracle.cabo.ui.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source)
    156. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    157. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    157 frames
  10. oracle.apps.fnd
    OABodyBean.render
    1. oracle.apps.fnd.framework.webui.beans.OABodyBean.render(OABodyBean.java:403)
    1 frame
  11. 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
  12. oracle.apps.fnd
    OAPageBean.renderDocument
    1. oracle.apps.fnd.framework.webui.OAPageBean.render(OAPageBean.java:3604)
    2. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3250)
    3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3055)
    3 frames