This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
jQuery in Action, 2nd edition
 
subject: Oracle 10g JDBC Error
 
Similar Threads
What is it?
using JDBC in WEBLOGIC
Debug an Oracle procedure fired from JDBC?
SQL Exception Weblogic9.1 Oracle 10g
Error Using JDrivers to Connect to Oracle