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 Cursor doubt in callable statement... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Cursor doubt in callable statement..." Watch "Cursor doubt in callable statement..." New topic

Cursor doubt in callable statement...

A Kumar
Ranch Hand

Joined: Jul 04, 2004
Posts: 980

In the below statement..

CallableStatement cst=conn.prepareCall("{ call MY_TEST_PROC(?,?,?) }");

I have to use....OracleTypes.CURSOR ...but for this...I have to use...

oracle driver.Is there any alternative to this that would make the code...not tie to oracle...

Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1082

I am not sure that it will work but you can try with Types.Other


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
I agree. Here's the link:
subject: Cursor doubt in callable statement...
It's not a secret anymore!