wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes Oracle 10g JDBC Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle 10g JDBC Error " Watch "Oracle 10g JDBC Error " New topic

Oracle 10g JDBC Error

Rajeev Iyer
Ranch Hand

Joined: Jun 19, 2002
Posts: 42

I am facing a problem when executing an oracle function that returns a ref cursor from Weblogic 8.1 SP4 with JRockit.
The error reads "Java.sql.SQLException:Bigger type length than maximum" when the first request is fired.when i fire the same request again, the error changes to "Java.sql.SQLException ALL8 is in an inconsistent state".
I am using the oracle thin driver versions :9.0.1,9.2.0,10 which is available when configuring the JDBC connetion pool from the weblogic console.

Can anyone help me out with this.

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

ALL8 is in an inconsistent state

This usually happens when you try to access a v9i database with v10i thin driver. Get the latest 10i driver from Oracle's site - I think they fixed this issue.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Rashid Darvesh
Ranch Hand

Joined: Feb 13, 2004
Posts: 189
I too have the same problem,
we upgraded our database to Oracle9i Enterprise Edition Release i tried with oracle 9i and 10g both ojdbc14.jar file and nothing helps. i am using a stmt.registerOutParameter(1, OracleTypes.CURSOR); to get an output as a cursor. BTW i am using weblogic 8.1

Any help on this
Srini Tanikonda

Joined: Jun 09, 2006
Posts: 1
I am also facing same problem. Can somebody please help. It is very Urgent

We are using the Thin Driver -- Websphere6.0 and Redhot Linux

The problem is with the REF_CURSOR.

I agree. Here's the link: http://aspose.com/file-tools
subject: Oracle 10g JDBC Error
It's not a secret anymore!