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

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_at_yahoo.com> 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>
>
>

--
http://www.freelists.org/webpage/oracle-l