8 Replies Latest reply: Mar 26, 2013 9:51 AM by Timo Hahn RSS

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

    Edward D.G.
      Im usign jdevloper 11.1.2.3.
      this error is shown when the master has details. But the error is at the master!!!!
      What is wrong hearre?

      SolicitudEncabezado and eoCliente are two Entity Objects.

      this is the log of error:

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT SolicitudEncabezado.COMPANIA,
      SolicitudEncabezado.SOLICITUD_NUMERO,
      SolicitudEncabezado.CLIENTE_GRUPO,
      SolicitudEncabezado.CLIENTE_NUMERO,
      eoCliente.NOMBRE,
      SolicitudEncabezado.MONEDA,
      SolicitudEncabezado.TERMINO_PAGO,
      SolicitudEncabezado.DIRECCION_ENVIO,
      SolicitudEncabezado.VENDEDOR_NUMERO,
      SolicitudEncabezado.ORDEN_COMPRA,
      SolicitudEncabezado.ESTADO,
      SolicitudEncabezado.USUARIO,
      SolicitudEncabezado.FECHA_SOLICITUD,
      SolicitudEncabezado.USUARIO_APROBACION,
      SolicitudEncabezado.FECHA_APROBACION,
      eoCliente.NO_CIA,
      eoCliente.GRUPO,
      eoCliente.NO_CLIENTE
      FROM SOLICITUD_ENCABEZADO SolicitudEncabezado, VENTAS.CLIENTE_V eoCliente
      WHERE SolicitudEncabezado.estado='O/C' and((SolicitudEncabezado.COMPANIA = eoCliente.NO_CIA(+)) AND (SolicitudEncabezado.CLIENTE_GRUPO = eoCliente.GRUPO(+))) AND (SolicitudEncabezado.CLIENTE_NUMERO = eoCliente.NO_CLIENTE(+)) AND
      (SolicitudEncabezado.compania,SolicitudEncabezado.solicitud_numero) not in ( select i.compania,i.solicitud_numero from solicitud_detalle i
      where solicitudencabezado.compania = i.compania
      and solicitudencabezado.solicitud_numero = i.solicitud_numero
      and i.estado_solicitud='O/P') and (SolicitudEncabezado.vendedor_numero =
      (select vendedor_numero from ventas.usuarios_web where usuario = upper(:pUsuario)) or (select vendedor_numero from ventas.usuarios_web where usuario = upper(:pUsuario)) is null)) QRSLT WHERE ((COMPANIA = :Bind_Compania AND SOLICITUD_NUMERO = :Bind_SolicitudNumero) AND COMPANIA = :fbkKy__0 AND SOLICITUD_NUMERO = :fbkKy__1)
      at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3721)
      at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4721)
      at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1379)
      at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
      at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
      at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
      at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
      at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
      at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
      at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17401)
      at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17049)
      at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5537)
      at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5296)
      at oracle.jbo.server.ViewObjectImpl.findByKey(ViewObjectImpl.java:11652)
      at oracle.jbo.server.EntityImpl.fetchExprValueSupplierOverrideRow(EntityImpl.java:635)
      at oracle.jbo.server.EntityImpl$ViewRowRef.getViewRow(EntityImpl.java:13284)
      at oracle.jbo.server.EntityImpl.getExprValueOverrideViewRow(EntityImpl.java:588)
      at oracle.jbo.server.JboMandatoryAttributesValidator.validate(JboMandatoryAttributesValidator.java:102)
      at oracle.jbo.server.EntityDefImpl.validate(EntityDefImpl.java:3095)
      at oracle.jbo.server.EntityCache.validate(EntityCache.java:3613)
      at oracle.jbo.server.EntityImpl.validateEntity(EntityImpl.java:2287)
      at oracle.jbo.server.EntityImpl.validate(EntityImpl.java:2466)
      at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4515)
      at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2008)
      at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2352)
      at oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1590)
      at oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1415)
      at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1428)
      at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169)
      at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731)
      at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193)
      at oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412)
      at oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112)
      at oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118)
      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      at java.awt.Component.processMouseEvent(Component.java:6289)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      at java.awt.Component.processEvent(Component.java:6054)
      at java.awt.Container.processEvent(Container.java:2041)
      at java.awt.Component.dispatchEventImpl(Component.java:4652)
      at java.awt.Container.dispatchEventImpl(Container.java:2099)
      at java.awt.Component.dispatchEvent(Component.java:4482)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      at java.awt.Container.dispatchEventImpl(Container.java:2085)
      at java.awt.Window.dispatchEventImpl(Window.java:2478)
      at java.awt.Component.dispatchEvent(Component.java:4482)
      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
      at java.awt.EventQueue.access$000(EventQueue.java:85)
      at java.awt.EventQueue$1.run(EventQueue.java:603)
      at java.awt.EventQueue$1.run(EventQueue.java:601)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
      at java.awt.EventQueue$2.run(EventQueue.java:617)
      at java.awt.EventQueue$2.run(EventQueue.java:615)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
      at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
      at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1254)
      ... 68 more
      ## Detail 0 ##
      java.sql.SQLException: Missing IN or OUT parameter at index:: 3
      at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
      at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1254)
      at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
      at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
      at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
      at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
      at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
      at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
      at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17401)
      at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17049)
      at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5537)
      at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5296)
      at oracle.jbo.server.ViewObjectImpl.findByKey(ViewObjectImpl.java:11652)
      at oracle.jbo.server.EntityImpl.fetchExprValueSupplierOverrideRow(EntityImpl.java:635)
      at oracle.jbo.server.EntityImpl$ViewRowRef.getViewRow(EntityImpl.java:13284)
      at oracle.jbo.server.EntityImpl.getExprValueOverrideViewRow(EntityImpl.java:588)
      at oracle.jbo.server.JboMandatoryAttributesValidator.validate(JboMandatoryAttributesValidator.java:102)
      at oracle.jbo.server.EntityDefImpl.validate(EntityDefImpl.java:3095)
      at oracle.jbo.server.EntityCache.validate(EntityCache.java:3613)
      at oracle.jbo.server.EntityImpl.validateEntity(EntityImpl.java:2287)
      at oracle.jbo.server.EntityImpl.validate(EntityImpl.java:2466)
      at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4515)
      at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2008)
      at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2352)
      at oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1590)
      at oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1415)
      at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1428)
      at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169)
      at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731)
      at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193)
      at oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412)
      at oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112)
      at oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118)
      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      at java.awt.Component.processMouseEvent(Component.java:6289)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      at java.awt.Component.processEvent(Component.java:6054)
      at java.awt.Container.processEvent(Container.java:2041)
      at java.awt.Component.dispatchEventImpl(Component.java:4652)
      at java.awt.Container.dispatchEventImpl(Container.java:2099)
      at java.awt.Component.dispatchEvent(Component.java:4482)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      at java.awt.Container.dispatchEventImpl(Container.java:2085)
      at java.awt.Window.dispatchEventImpl(Window.java:2478)
      at java.awt.Component.dispatchEvent(Component.java:4482)
      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
      at java.awt.EventQueue.access$000(EventQueue.java:85)
      at java.awt.EventQueue$1.run(EventQueue.java:603)
      at java.awt.EventQueue$1.run(EventQueue.java:601)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
      at java.awt.EventQueue$2.run(EventQueue.java:617)
      at java.awt.EventQueue$2.run(EventQueue.java:615)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
        • 3. Re: RARE: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
          Edward D.G.
          which parameter is at index:: 3??? index begin at 0 or 1?
          • 4. Re: RARE: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
            Suresh Karunarathne
            Hi,
            Did you set following parameters run time,Are you using view criteria or only query run with query parameters
            pUsuario
            Bind_Compania
            Bind_SolicitudNumero
            fbkKy__0fbkKy__1
            • 5. Re: RARE: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
              Frank Nimphius-Oracle
              Hi,

              have you read this: https://blogs.oracle.com/jdevotnharvest/entry/the_infamous_missing_in_or

              Frank
              • 6. Re: RARE: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
                Edward D.G.
                Hi Frank, yes, i did it. But parameter "pUsuario" is required and its default expresion value is adf.context.securityContext.userName.
                The primary key is compositive (varchar2, number) and i use a db sequence in pre-insert trigger.

                (Bind_Compania and Bind_SolicitudNumero: bind variables of the view link. they are primary key.
                fbkKy__0 and fbkKy__1: i dont know.
                • 7. Re: RARE: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
                  Edward D.G.
                  This is the log. "caused params changed" is the error source of "java.sql.SQLException: Missing IN or OUT parameter at index:: 2"???


                  [2038] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.setWhereClauseParams caused params changed
                  [2039] Evaluating Script with name:pUsuario, Type : Groovy. Expression:
                  [2040] adf.context.securityContext.userName
                  [2041] Evaluation result:egalvez
                  [2042] eoSolicitudDetalle_SolicitudEncabezadoView_FkSolicitudEncDetLink_voSolicitudEncabezado ViewRowSetImpl.doSetWhereClause(-1, pUsuario, egalvez)
                  [2043] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.setWhereClauseParams caused params changed
                  [2044] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.setWhereClauseParams caused params changed
                  [2045] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.setNamedWhereClauseParam(pUsuario, egalvez)
                  [2046] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.setNamedWhereClauseParam(fbkKy__0, 01)
                  [2047] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.setNamedWhereClauseParam(fbkKy__1, -9)
                  [2048] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.doSetWhereClause(-1, pUsuario, egalvez)
                  [2049] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.doSetWhereClause(-1, fbkKy__0, 01)
                  [2050] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.doSetWhereClause(-1, fbkKy__1, -9)
                  [2051] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.execute caused params to be "un"changed
                  [2052] Carrying over CappedRowCount:-1for ViewRowSet:voSolicitudEncabezado_112_findByKey_
                  [2053] Column count: 27
                  [2054] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.doSetWhereClause(-1, pUsuario, egalvez)
                  [2055] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.doSetWhereClause(-1, fbkKy__0, 01)
                  [2056] voSolicitudEncabezado_112_findByKey_ ViewRowSetImpl.doSetWhereClause(-1, fbkKy__1, -9)
                  [2057] executeQueryForCollection ViewObject:voSolicitudEncabezado_112_findByKey_, RowSet:voSolicitudEncabezado_112_findByKey_
                  [2058] ViewObject: [model.vo.voSolicitudEncabezado]AppVentas.voSolicitudEncabezado_112_findByKey_ close prepared statements...
                  [2059] ViewObject: [model.vo.voSolicitudEncabezado]AppVentas.voSolicitudEncabezado_112_findByKey_ Created new QUERY statement
                  [2060] voSolicitudEncabezado_112_findByKey_>#q computed SQLStmtBufLen: 1588, actual=1570, storing=1600
                  [2061] SELECT * FROM (SELECT SolicitudEncabezado.COMPANIA,
                  SolicitudEncabezado.SOLICITUD_NUMERO,
                  SolicitudEncabezado.CLIENTE_GRUPO,
                  SolicitudEncabezado.CLIENTE_NUMERO,
                  eoCliente.NOMBRE,
                  SolicitudEncabezado.MONEDA,
                  SolicitudEncabezado.TERMINO_PAGO,
                  SolicitudEncabezado.DIRECCION_ENVIO,
                  SolicitudEncabezado.VENDEDOR_NUMERO,
                  SolicitudEncabezado.ORDEN_COMPRA,
                  SolicitudEncabezado.ESTADO,
                  SolicitudEncabezado.USUARIO,
                  SolicitudEncabezado.FECHA_SOLICITUD,
                  SolicitudEncabezado.USUARIO_APROBACION,
                  SolicitudEncabezado.FECHA_APROBACION,
                  eoCliente.NO_CIA,
                  eoCliente.GRUPO,
                  eoCliente.NO_CLIENTE
                  FROM SOLICITUD_ENCABEZADO SolicitudEncabezado, VENTAS.CLIENTE_V eoCliente
                  WHERE SolicitudEncabezado.estado='O/C' and((SolicitudEncabezado.COMPANIA = eoCliente.NO_CIA(+)) AND (SolicitudEncabezado.CLIENTE_GRUPO = eoCliente.GRUPO(+))) AND (SolicitudEncabezado.CLIENTE_NUMERO = eoCliente.NO_CLIENTE(+)) AND
                  (SolicitudEncabezado.compania,SolicitudEncabezado.solicitud_numero) not in ( select i.compania,i.solicitud_numero from solicitud_detalle i
                  where solicitudencabezado.compania = i.compania
                  and solicitudencabezado.solicitud_numero = i.solicitud_numero
                  and i.estado_solicitud='O/P') and (SolicitudEncabezado.vendedor_numero =
                  (select vendedor_numero from ventas.usuarios_web where usuario = upper(:pUsuario)))) QRSLT WHERE ((COMPANIA = :Bind_Compania AND SOLICITUD_NUMERO = :Bind_SolicitudNumero) AND COMPANIA = :fbkKy__0 AND SOLICITUD_NUMERO = :fbkKy__1)
                  [2062] Bind params for ViewObject: [model.vo.voSolicitudEncabezado]AppVentas.voSolicitudEncabezado_112_findByKey_
                  [2063] Binding param "pUsuario": egalvez
                  [2064] Binding param "fbkKy__0": 01
                  [2065] Binding null of type 12 for "fbkKy__1"
                  [2066] ViewObject: [model.vo.voSolicitudEncabezado]AppVentas.voSolicitudEncabezado_112_findByKey_ close single-use prepared statements
                  [2067] QueryCollection.executeQuery failed...
                  [2068] java.sql.SQLException: Missing IN or OUT parameter at index:: 2
                       at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
                       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
                       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
                       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
                       at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1254)
                       at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
                       at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
                       at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
                       at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
                       at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
                       at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
                       at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17401)
                       at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17049)
                       at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5537)
                       at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5296)
                       at oracle.jbo.server.ViewObjectImpl.findByKey(ViewObjectImpl.java:11652)
                       at oracle.jbo.server.EntityImpl.fetchExprValueSupplierOverrideRow(EntityImpl.java:635)
                       at oracle.jbo.server.EntityImpl$ViewRowRef.getViewRow(EntityImpl.java:13284)
                       at oracle.jbo.server.EntityImpl.getExprValueOverrideViewRow(EntityImpl.java:588)
                       at oracle.jbo.server.JboMandatoryAttributesValidator.validate(JboMandatoryAttributesValidator.java:102)
                       at oracle.jbo.server.EntityDefImpl.validate(EntityDefImpl.java:3095)
                       at oracle.jbo.server.EntityCache.validate(EntityCache.java:3613)
                       at oracle.jbo.server.EntityImpl.validateEntity(EntityImpl.java:2287)
                       at oracle.jbo.server.EntityImpl.validate(EntityImpl.java:2466)
                       at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4515)
                       at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2008)
                       at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2352)
                       at oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1590)
                       at oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1415)
                       at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1428)
                       at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169)
                       at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731)
                       at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193)
                       at oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412)
                       at oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112)
                       at oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118)
                       at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                       at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                       at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                       at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                       at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                       at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
                       at java.awt.Component.processMouseEvent(Component.java:6289)
                       at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                       at java.awt.Component.processEvent(Component.java:6054)
                       at java.awt.Container.processEvent(Container.java:2041)
                       at java.awt.Component.dispatchEventImpl(Component.java:4652)
                       at java.awt.Container.dispatchEventImpl(Container.java:2099)
                       at java.awt.Component.dispatchEvent(Component.java:4482)
                       at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                       at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                       at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                       at java.awt.Container.dispatchEventImpl(Container.java:2085)
                       at java.awt.Window.dispatchEventImpl(Window.java:2478)
                       at java.awt.Component.dispatchEvent(Component.java:4482)
                       at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
                       at java.awt.EventQueue.access$000(EventQueue.java:85)
                       at java.awt.EventQueue$1.run(EventQueue.java:603)
                       at java.awt.EventQueue$1.run(EventQueue.java:601)
                       at java.security.AccessController.doPrivileged(Native Method)
                       at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
                       at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
                       at java.awt.EventQueue$2.run(EventQueue.java:617)
                       at java.awt.EventQueue$2.run(EventQueue.java:615)
                       at java.security.AccessController.doPrivileged(Native Method)
                       at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
                       at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
                       at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                       at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                       at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
                       at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
                       at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
                       at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

                  [2069] voSolicitudEncabezado_112_findByKey_>#q old SQLStmtBufLen: 1600, actual=1570, storing=1600
                  [2070] SELECT * FROM (SELECT SolicitudEncabezado.COMPANIA,
                  SolicitudEncabezado.SOLICITUD_NUMERO,
                  SolicitudEncabezado.CLIENTE_GRUPO,
                  SolicitudEncabezado.CLIENTE_NUMERO,
                  eoCliente.NOMBRE,
                  SolicitudEncabezado.MONEDA,
                  SolicitudEncabezado.TERMINO_PAGO,
                  SolicitudEncabezado.DIRECCION_ENVIO,
                  SolicitudEncabezado.VENDEDOR_NUMERO,
                  SolicitudEncabezado.ORDEN_COMPRA,
                  SolicitudEncabezado.ESTADO,
                  SolicitudEncabezado.USUARIO,
                  SolicitudEncabezado.FECHA_SOLICITUD,
                  SolicitudEncabezado.USUARIO_APROBACION,
                  SolicitudEncabezado.FECHA_APROBACION,
                  eoCliente.NO_CIA,
                  eoCliente.GRUPO,
                  eoCliente.NO_CLIENTE
                  FROM SOLICITUD_ENCABEZADO SolicitudEncabezado, VENTAS.CLIENTE_V eoCliente
                  WHERE SolicitudEncabezado.estado='O/C' and((SolicitudEncabezado.COMPANIA = eoCliente.NO_CIA(+)) AND (SolicitudEncabezado.CLIENTE_GRUPO = eoCliente.GRUPO(+))) AND (SolicitudEncabezado.CLIENTE_NUMERO = eoCliente.NO_CLIENTE(+)) AND
                  (SolicitudEncabezado.compania,SolicitudEncabezado.solicitud_numero) not in ( select i.compania,i.solicitud_numero from solicitud_detalle i
                  where solicitudencabezado.compania = i.compania
                  and solicitudencabezado.solicitud_numero = i.solicitud_numero
                  and i.estado_solicitud='O/P') and (SolicitudEncabezado.vendedor_numero =
                  (select vendedor_numero from ventas.usuarios_web where usuario = upper(:pUsuario)))) QRSLT WHERE ((COMPANIA = :Bind_Compania AND SOLICITUD_NUMERO = :Bind_SolicitudNumero) AND COMPANIA = :fbkKy__0 AND SOLICITUD_NUMERO = :fbkKy__1)
                  [2071] DCBindingContainer.reportException :oracle.jbo.SQLStmtException
                  [2072] oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT SolicitudEncabezado.COMPANIA,
                  SolicitudEncabezado.SOLICITUD_NUMERO,
                  SolicitudEncabezado.CLIENTE_GRUPO,
                  SolicitudEncabezado.CLIENTE_NUMERO,
                  eoCliente.NOMBRE,
                  SolicitudEncabezado.MONEDA,
                  SolicitudEncabezado.TERMINO_PAGO,
                  SolicitudEncabezado.DIRECCION_ENVIO,
                  SolicitudEncabezado.VENDEDOR_NUMERO,
                  SolicitudEncabezado.ORDEN_COMPRA,
                  SolicitudEncabezado.ESTADO,
                  SolicitudEncabezado.USUARIO,
                  SolicitudEncabezado.FECHA_SOLICITUD,
                  SolicitudEncabezado.USUARIO_APROBACION,
                  SolicitudEncabezado.FECHA_APROBACION,
                  eoCliente.NO_CIA,
                  eoCliente.GRUPO,
                  eoCliente.NO_CLIENTE
                  FROM SOLICITUD_ENCABEZADO SolicitudEncabezado, VENTAS.CLIENTE_V eoCliente
                  WHERE SolicitudEncabezado.estado='O/C' and((SolicitudEncabezado.COMPANIA = eoCliente.NO_CIA(+)) AND (SolicitudEncabezado.CLIENTE_GRUPO = eoCliente.GRUPO(+))) AND (SolicitudEncabezado.CLIENTE_NUMERO = eoCliente.NO_CLIENTE(+)) AND
                  (SolicitudEncabezado.compania,SolicitudEncabezado.solicitud_numero) not in ( select i.compania,i.solicitud_numero from solicitud_detalle i
                  where solicitudencabezado.compania = i.compania
                  and solicitudencabezado.solicitud_numero = i.solicitud_numero
                  and i.estado_solicitud='O/P') and (SolicitudEncabezado.vendedor_numero =
                  (select vendedor_numero from ventas.usuarios_web where usuario = upper(:pUsuario)))) QRSLT WHERE ((COMPANIA = :Bind_Compania AND SOLICITUD_NUMERO = :Bind_SolicitudNumero) AND COMPANIA = :fbkKy__0 AND SOLICITUD_NUMERO = :fbkKy__1)
                       at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3721)
                       at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4721)
                       at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1379)
                       at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
                       at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
                       at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
                       at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
                       at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
                       at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
                       at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17401)
                       at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17049)
                       at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5537)
                       at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5296)
                       at oracle.jbo.server.ViewObjectImpl.findByKey(ViewObjectImpl.java:11652)
                       at oracle.jbo.server.EntityImpl.fetchExprValueSupplierOverrideRow(EntityImpl.java:635)
                       at oracle.jbo.server.EntityImpl$ViewRowRef.getViewRow(EntityImpl.java:13284)
                       at oracle.jbo.server.EntityImpl.getExprValueOverrideViewRow(EntityImpl.java:588)
                       at oracle.jbo.server.JboMandatoryAttributesValidator.validate(JboMandatoryAttributesValidator.java:102)
                       at oracle.jbo.server.EntityDefImpl.validate(EntityDefImpl.java:3095)
                       at oracle.jbo.server.EntityCache.validate(EntityCache.java:3613)
                       at oracle.jbo.server.EntityImpl.validateEntity(EntityImpl.java:2287)
                       at oracle.jbo.server.EntityImpl.validate(EntityImpl.java:2466)
                       at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4515)
                       at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2008)
                       at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2352)
                       at oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1590)
                       at oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1415)
                       at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1428)
                       at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169)
                       at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731)
                       at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193)
                       at oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412)
                       at oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112)
                       at oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118)
                       at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                       at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                       at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                       at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                       at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                       at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
                       at java.awt.Component.processMouseEvent(Component.java:6289)
                       at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                       at java.awt.Component.processEvent(Component.java:6054)
                       at java.awt.Container.processEvent(Container.java:2041)
                       at java.awt.Component.dispatchEventImpl(Component.java:4652)
                       at java.awt.Container.dispatchEventImpl(Container.java:2099)
                       at java.awt.Component.dispatchEvent(Component.java:4482)
                       at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                       at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                       at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                       at java.awt.Container.dispatchEventImpl(Container.java:2085)
                       at java.awt.Window.dispatchEventImpl(Window.java:2478)
                       at java.awt.Component.dispatchEvent(Component.java:4482)
                       at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
                       at java.awt.EventQueue.access$000(EventQueue.java:85)
                       at java.awt.EventQueue$1.run(EventQueue.java:603)
                       at java.awt.EventQueue$1.run(EventQueue.java:601)
                       at java.security.AccessController.doPrivileged(Native Method)
                       at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
                       at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
                       at java.awt.EventQueue$2.run(EventQueue.java:617)
                       at java.awt.EventQueue$2.run(EventQueue.java:615)
                       at java.security.AccessController.doPrivileged(Native Method)
                       at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
                       at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
                       at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                       at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                       at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
                       at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
                       at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
                       at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
                  Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 2
                       at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
                       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
                       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
                       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
                       at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1254)
                       ... 68 more
                  ## Detail 0 ##
                  java.sql.SQLException: Missing IN or OUT parameter at index:: 2
                       at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
                       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
                       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
                       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
                       at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1254)
                       at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
                       at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
                       at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
                       at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
                       at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
                       at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
                       at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17401)
                       at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17049)
                       at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5537)
                       at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5296)
                       at oracle.jbo.server.ViewObjectImpl.findByKey(ViewObjectImpl.java:11652)
                       at oracle.jbo.server.EntityImpl.fetchExprValueSupplierOverrideRow(EntityImpl.java:635)
                       at oracle.jbo.server.EntityImpl$ViewRowRef.getViewRow(EntityImpl.java:13284)
                       at oracle.jbo.server.EntityImpl.getExprValueOverrideViewRow(EntityImpl.java:588)
                       at oracle.jbo.server.JboMandatoryAttributesValidator.validate(JboMandatoryAttributesValidator.java:102)
                       at oracle.jbo.server.EntityDefImpl.validate(EntityDefImpl.java:3095)
                       at oracle.jbo.server.EntityCache.validate(EntityCache.java:3613)
                       at oracle.jbo.server.EntityImpl.validateEntity(EntityImpl.java:2287)
                       at oracle.jbo.server.EntityImpl.validate(EntityImpl.java:2466)
                       at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4515)
                       at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2008)
                       at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2352)
                       at oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1590)
                       at oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1415)
                       at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1428)
                       at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169)
                       at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731)
                       at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193)
                       at oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412)
                       at oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112)
                       at oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118)
                       at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                       at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                       at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                       at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                       at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                       at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
                       at java.awt.Component.processMouseEvent(Component.java:6289)
                       at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                       at java.awt.Component.processEvent(Component.java:6054)
                       at java.awt.Container.processEvent(Container.java:2041)
                       at java.awt.Component.dispatchEventImpl(Component.java:4652)
                       at java.awt.Container.dispatchEventImpl(Container.java:2099)
                       at java.awt.Component.dispatchEvent(Component.java:4482)
                       at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                       at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                       at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                       at java.awt.Container.dispatchEventImpl(Container.java:2085)
                       at java.awt.Window.dispatchEventImpl(Window.java:2478)
                       at java.awt.Component.dispatchEvent(Component.java:4482)
                       at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
                       at java.awt.EventQueue.access$000(EventQueue.java:85)
                       at java.awt.EventQueue$1.run(EventQueue.java:603)
                       at java.awt.EventQueue$1.run(EventQueue.java:601)
                       at java.security.AccessController.doPrivileged(Native Method)
                       at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
                       at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
                       at java.awt.EventQueue$2.run(EventQueue.java:617)
                       at java.awt.EventQueue$2.run(EventQueue.java:615)
                       at java.security.AccessController.doPrivileged(Native Method)
                       at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
                       at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
                       at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                       at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                       at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
                       at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
                       at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
                       at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

                  [2073] JUErrorHandlerDlg.reportException(oracle.jbo.SQLStmtException)
                  [2074] ##### QueryCollection.finl oracle.jbo.Key[egalvez 01 -9 ]
                  • 8. Re: RARE: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
                    Timo Hahn
                    Edward, I have to say that I'm a bit lost in your post. I don't understand what's going on but one thing you can test is changing the manner yoru queries are built.
                    I'm talking about
                    select * from (select YOUR_ATTRIBUTES,... where ATTRIBUTES = :bindVar) QRSLT where (ANOTHER_ATTRIBUTE = :binVar2)
                    As you see the query builder puts a select * from around your original query and then adds another where clause part to it. Sometimes I saw the 'Missing IN or OUT parameter at index:: 2' error because of this. Not sure why this happed but it does. After telling the querybuilder to just use the original query the problem where gone. There are some things to think about if you do this. Reffer to thsi old Post http://radio-weblogs.com/0118231/stories/2003/03/07/viewObjectsViewDefinitionsAndRuntimeWhereClauseHandling.html which give some detail.
                    Apointer to the doc http://docs.oracle.com/cd/E21764_01/web.1111/b31974/bcquerying.htm#CHDGCCBC '5.9.4 What You May Need to Know About Expert Mode'
                    After you understood all this you cna try the code below on your VO and again, I'm not sure it helps t osolve your problem.
                      // overridden framework method in YourViewNameImpl.java
                      public void create() {
                        super.create();
                        setNestedSelectForFullSql(false);
                      }
                    Timo