wood burning stoves 2.0*
The moose likes JDBC and the fly likes Bigger type length than Maximum with OracleType.CURSOR Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Bigger type length than Maximum with OracleType.CURSOR" Watch "Bigger type length than Maximum with OracleType.CURSOR" New topic
Author

Bigger type length than Maximum with OracleType.CURSOR

jiangang lan
Greenhorn

Joined: Dec 22, 2005
Posts: 2
I'm getting one SQLException When I execute one query which try to open one oracle cursor.

My jdk version is 1.4.2_08 and oracle version is 10g Enterprise Edition Release 10.1.0.4.0. And I use ojdbc14_g.jar and orai18n in CLASSPATH.

My code and my table is very simple:


And there is only one row in the table.And I can get all the results by one single sql "select * from hello".

The trace:



Any idea ,is it a driver problem or something i need to do?
Thanks.
jiangang lan
Greenhorn

Joined: Dec 22, 2005
Posts: 2
By the way, I have tried the example of RefcursorSample offered by oraclesource
I got the same exception too. So I think it is a driver problem. But I don't known how to fix it.
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Originally posted by jiangang lan:
My jdk version is 1.4.2_08 and oracle version is 10g Enterprise Edition Release 10.1.0.4.0. And I use ojdbc14_g.jar and orai18n in CLASSPATH.
Any idea ,is it a driver problem or something i need to do?
Thanks.


I don't know, but you can certainly try the latest driver; it's cross-compatible with the older database that you are using.

You can download it from here:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Bigger type length than Maximum with OracleType.CURSOR