Re: Upgrade from ORACLE 10.2.0.2 to 10.20.0.3 and get Java error

  • From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Mon, 4 Feb 2008 10:47:11 -0500

Hi,

There are plenty of bugs reported on Metalink related to 10g and ORA-932
error.

6343883
4644048

I would really recommend to check them out and decide what applies to your
case.

--romas


On 2/4/08, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
>
> 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://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>
>
>

Other related posts: