• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle 10g JDBC Error

 
Rajeev Iyer
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
 
Rashid Darvesh
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic