This discussion is archived
8 Replies Latest reply: Mar 26, 2013 7:51 AM by Timo Hahn RSS

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

Edward D.G. Newbie
Currently Being Moderated
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)
  • 2. Re: RARE: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
    Puthanampatti Guru
    Currently Being Moderated
    run the AM itself and debug.
  • 3. Re: RARE: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
    Edward D.G. Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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. Newbie
    Currently Being Moderated
    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. Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points