File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "Oracle 10g JDBC Error " Watch "Oracle 10g JDBC Error " New topic
Author

Oracle 10g JDBC Error

Rajeev Iyer
Ranch Hand

Joined: Jun 19, 2002
Posts: 42
Hi,

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.

Thanks
Rajeev
Paul Sturrock
Bartender

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 9.2.0.7.0. 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
Greenhorn

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

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

The problem is with the REF_CURSOR.


Regards
Srini
 
 
subject: Oracle 10g JDBC Error