java.sql.SQLException

Missing IN or OUT parameter at index:: 1

Solutions on the web9441

  • via Coderanch by Basant Mobiya, 6 months ago
    Missing IN or OUT parameter at index:: 1
  • Missing IN or OUT parameter at index:: 1
  • via Google Groups by Oliver Ehrenmüller, 6 months ago
    Missing IN or OUT parameter at index:: 1
  • Stack trace

    • java.sql.SQLException: Missing IN or OUT parameter at index:: 1 at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439) at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.createListDataObject(OAWebBeanPickListHelper.java:992) at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getListDataObject(OAWebBeanPickListHelper.java:837) at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getList(OAWebBeanPickListHelper.java:465) at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getList(OAWebBeanPickListHelper.java:404) at oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getList(OAMessageChoiceBean.java:762) at oracle.apps.fnd.framework.webui.OADataBoundValuePickListData.getValue(OADataBoundValuePickListData.java:86) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1809) at oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(OAMessageChoiceBean.java:369) at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source) at oracle.apps.fnd.framework.webui.OADataBoundValuePickListSelectionIndex.getValue(OADataBoundValuePickListSelectionIndex.java:61) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1809) at oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(OAMessageChoiceBean.java:369) at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source) at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source) at oracle.cabo.ui.collection.AttributeMapProxy.getAttribute(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source) at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValue(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, 6 hours ago
    Unknown user
    Once, 6 hours ago
    Unknown user
    Once, 6 hours ago
    Unknown user
    Once, 6 hours ago
    Unknown user
    Once, 6 hours ago
    132 more bugmates