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

Oracle Community | AlkaT. | 4 years ago
  1. 0

    Error with bind parameter

    Oracle Community | 4 years ago | AlkaT.
    java.sql.SQLException: Missing IN or OUT parameter at index:: 2
  2. 0

    HGrid not working in R12   using jdeveloper 10.1.3.3

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

    repeated bind parameters in where clause of ViewLink in OAF in R12 insta

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

    Decode using bind variable in SQL

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

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

    Oracle Community | 7 years ago | Yogi
    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:: 2

      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
      ViewRowSetImpl.first
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)
      2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:687)
      3. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2657)
      4. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2634)
      5. oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1474)
      6. oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2827)
      6 frames
    6. oracle.apps.fnd
      OAHierarchyData.selectValue
      1. oracle.apps.fnd.framework.webui.OAHierarchyData.getExpandableState(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAHGridData.getExpandableState(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAHGridData.selectGoodValue(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAHierarchyData.selectValue(Unknown Source)
      4 frames
    7. oracle.cabo.ui
      BaseUINode.render
      1. oracle.cabo.ui.data.tree.TreeState._buildInternalRep(Unknown Source)
      2. oracle.cabo.ui.data.tree.TreeState.<init>(Unknown Source)
      3. oracle.cabo.ui.data.tree.ClientStateHGridDataProxy._createState(Unknown Source)
      4. oracle.cabo.ui.data.tree.ClientStateHGridDataProxy.getFocusRoot(Unknown Source)
      5. oracle.cabo.ui.laf.base.desktop.table.HGridRenderingContext.getTableDataFromBean(Unknown Source)
      6. oracle.cabo.ui.laf.base.xhtml.TableRenderingContext.<init>(Unknown Source)
      7. oracle.cabo.ui.laf.base.desktop.table.HGridRenderingContext.<init>(Unknown Source)
      8. oracle.cabo.ui.laf.base.desktop.HGridRenderer.createRenderingContext(Unknown Source)
      9. oracle.cabo.ui.laf.base.xhtml.TableRenderer.getTableRenderingContext(Unknown Source)
      10. oracle.cabo.ui.laf.base.xhtml.TableRenderer.renderContent(Unknown Source)
      11. oracle.cabo.ui.laf.base.desktop.TableRenderer.renderContent(Unknown Source)
      12. oracle.cabo.ui.laf.base.desktop.HGridRenderer.renderContent(Unknown Source)
      13. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      14. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      15. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      16. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      17. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      18. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      19. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      20. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      21. oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source)
      22. oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderContent(Unknown Source)
      23. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      24. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      25. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      26. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      27. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      28. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      29. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      30. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      31. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      32. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      33. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      34. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      35. oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source)
      36. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      37. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      38. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      39. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      40. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      41. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      42. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      43. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      44. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      45. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      46. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      47. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source)
      48. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      49. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      50. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      51. oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
      52. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source)
      53. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      54. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      55. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      56. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      57. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
      58. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      59. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      60. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      61. oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source)
      62. oracle.cabo.ui.laf.swan.desktop.ContentRenderer.renderContent(Unknown Source)
      63. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      64. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.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.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
      73. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      74. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      75. oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
      76. oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source)
      77. oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.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.BaseRenderer.renderIndexedChild(Unknown Source)
      90. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
      91. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
      92. oracle.cabo.ui.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source)
      93. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
      94. oracle.cabo.ui.BaseUINode.render(Unknown Source)
      94 frames
    8. oracle.apps.fnd
      OABodyBean.render
      1. oracle.apps.fnd.framework.webui.beans.OABodyBean.render(Unknown Source)
      1 frame
    9. 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
    10. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.webui.OAPageBean.render(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)
      3 frames