java.sql.SQLException: ORA-01008: not all variables bound

Oracle Community | user539616 | 6 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Seeded Page is erroring out in JDeveloper

    Oracle Community | 1 decade ago | Adarsh Kumar
    java.sql.SQLException: ORA-01008: not all variables bound
  2. 0

    customizing the oaf page

    Oracle Community | 6 years ago | user539616
    java.sql.SQLException: ORA-01008: not all variables bound
  3. 0

    JBO27122 ERROR with ViewLink --pls do the need ful

    Oracle Community | 8 years ago | UmaMaddi
    java.sql.SQLException: ORA-01008: not all variables bound
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    error in extending a region

    Oracle Community | 9 years ago | 604446
    java.sql.SQLException: ORA-01008: not all variables bound
  6. 0

    Controller extension

    Oracle Community | 8 years ago | Rakesh S
    java.sql.SQLException: ORA-01008: not all variables bound

  1. rp 1 times, last 3 months ago
26 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

    ORA-01008: not all variables bound

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1141)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2487)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2854)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:622)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:550)
    4 frames
  5. oracle.jbo.server
    OAJboViewObjectImpl.executeQueryForCollection
    1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:627)
    2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:515)
    3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3347)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:825)
    4 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4465)
    1 frame
  7. oracle.jbo.server
    ViewObjectImpl.first
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
    2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:538)
    3. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2369)
    4. oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:2586)
    5. oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:1674)
    6. oracle.jbo.server.ViewRowSetImpl.refreshRowSet(ViewRowSetImpl.java:3703)
    7. oracle.jbo.server.ViewRowSetIteratorImpl.notifyDetailRowSets(ViewRowSetIteratorImpl.java:3018)
    8. oracle.jbo.server.ViewRowSetIteratorImpl.notifyNavigation(ViewRowSetIteratorImpl.java:3126)
    9. oracle.jbo.server.ViewRowSetIteratorImpl.internalSetCurrentRow(ViewRowSetIteratorImpl.java:2910)
    10. oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1257)
    11. oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2363)
    12. oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:5231)
    12 frames
  8. oracle.apps.fnd
    OAHGridBean.getAttributeValueImpl
    1. oracle.apps.fnd.framework.webui.OADataBoundValueHGrid.getValue(OADataBoundValueHGrid.java:85)
    2. oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1760)
    3. oracle.apps.fnd.framework.webui.beans.table.OAHGridBean.getAttributeValueImpl(OAHGridBean.java:509)
    3 frames
  9. oracle.cabo.ui
    BaseUINode.render
    1. oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
    2. oracle.cabo.ui.laf.base.desktop.table.HGridRenderingContext.getTableDataFromBean(Unknown Source)
    3. oracle.cabo.ui.laf.base.xhtml.TableRenderingContext.<init>(Unknown Source)
    4. oracle.cabo.ui.laf.base.desktop.table.HGridRenderingContext.<init>(Unknown Source)
    5. oracle.cabo.ui.laf.base.desktop.HGridRenderer.createRenderingContext(Unknown Source)
    6. oracle.cabo.ui.laf.base.xhtml.TableRenderer.getTableRenderingContext(Unknown Source)
    7. oracle.cabo.ui.laf.base.xhtml.TableRenderer.renderContent(Unknown Source)
    8. oracle.cabo.ui.laf.base.desktop.TableRenderer.renderContent(Unknown Source)
    9. oracle.cabo.ui.laf.base.desktop.HGridRenderer.renderContent(Unknown Source)
    10. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    11. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    12. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    13. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    14. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    15. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    16. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    17. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    18. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    19. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    20. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    21. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    22. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    23. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    24. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    25. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    26. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    27. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    28. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    29. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    30. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    31. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    32. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    33. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    34. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    35. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    36. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    37. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    38. oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source)
    39. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    40. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    41. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    42. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    43. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    44. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    45. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    46. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    47. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    48. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    49. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    50. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    51. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    52. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    53. oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
    54. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    55. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    56. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    57. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    58. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    59. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    60. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    61. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    62. oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source)
    63. oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderContent(Unknown Source)
    64. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    65. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    66. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    67. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    68. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    69. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    70. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    71. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    72. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    73. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    74. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    75. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    76. oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
    77. oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source)
    78. oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.render(Unknown Source)
    79. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    80. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    81. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    82. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    83. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    84. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    85. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    86. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    87. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    88. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    89. oracle.cabo.ui.BaseRenderer.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.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source)
    94. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    95. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    95 frames
  10. oracle.apps.fnd
    OABodyBean.render
    1. oracle.apps.fnd.framework.webui.beans.OABodyBean.render(OABodyBean.java:398)
    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:3209)
    2. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2888)
    3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2700)
    3 frames