Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Edward D.G.Mar 16 2013 — edited Mar 26 2013

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)

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2013

Added on Mar 16 2013

#adf, #application-development-in-java, #developer, #faces, #java, #jdev, #jdeveloper-and-adf

8 comments

791 views