java.sql.SQLException

Missing IN or OUT parameter at index:: 2

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web8840

  • via Oracle Community by 3004, 2 weeks ago
    Missing IN or OUT parameter at index:: 2 log3:
  • via Oracle Community by 3004, 1 year ago
    Missing IN or OUT parameter at index:: 2
  • Missing IN or OUT parameter at index:: 2
  • Stack trace

    • java.sql.SQLException: Missing IN or OUT parameter at index:: 2 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175) at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1566) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2996) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:857) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:666) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3655) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(Unknown Source) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:687) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2657) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2634) at oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1474) at oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2827) at oracle.apps.fnd.framework.webui.OAHierarchyData.getExpandableState(Unknown Source) at oracle.apps.fnd.framework.webui.OAHGridData.getExpandableState(Unknown Source) at oracle.apps.fnd.framework.webui.OAHGridData.selectGoodValue(Unknown Source) at oracle.apps.fnd.framework.webui.OAHierarchyData.selectValue(Unknown Source) at oracle.cabo.ui.data.tree.TreeState._buildInternalRep(Unknown Source) at oracle.cabo.ui.data.tree.TreeState.<init>(Unknown Source) at oracle.cabo.ui.data.tree.ClientStateHGridDataProxy._createState(Unknown Source) at oracle.cabo.ui.data.tree.ClientStateHGridDataProxy.getFocusRoot(Unknown Source) at oracle.cabo.ui.laf.base.desktop.table.HGridRenderingContext.getTableDataFromBean(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.TableRenderingContext.<init>(Unknown Source) at oracle.cabo.ui.laf.base.desktop.table.HGridRenderingContext.<init>(Unknown Source) at oracle.cabo.ui.laf.base.desktop.HGridRenderer.createRenderingContext(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.TableRenderer.getTableRenderingContext(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.TableRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.desktop.TableRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.desktop.HGridRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.ContentRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source) at oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.apps.fnd.framework.webui.beans.OABodyBean.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.partial.PartialPageUtils.renderPartialPage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.render(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 9 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    76 more bugmates