Upgrade from ORACLE 10.2.0.2 to 10.20.0.3 and get Java error

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 4 Feb 2008 07:23:56 -0800 (PST)
Message-ID: <419148.77830.qm@web60825.mail.yahoo.com>


We upgraded from ORACLE 10.2.0.2 to 10.2.0.3 and get error ORA-00932.

Does anyone know why?


java.sql.SQLException: ORA-00932: inconsistent datatypes: expected an OUT argument at position 2 that is a java.sql.ResultSet got a java.sql.ResultSet that can not be used as a REF CURSOR   

             at  oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
             at  oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
             at  oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
             at  oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1957)
             at  oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1114)
             at  oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2181)


       

---------------------------------

Never miss a thing. Make Yahoo your homepage.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 04 2008 - 09:23:56 CST

Original text of this message