File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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:
subject: Oracle 10g JDBC Error
It's not a secret anymore!