Upgrade from ORACLE 10.2.0.2 to 10.20.0.3 and get Java error

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 4 Feb 2008 07:23:56 -0800 (PST)

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.

Other related posts: