Upgrade from ORACLE to 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 to 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