jQuery in Action, 2nd edition*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Cursor doubt in callable statement..." Watch "Cursor doubt in callable statement..." New topic
Author

Cursor doubt in callable statement...

A Kumar
Ranch Hand

Joined: Jul 04, 2004
Posts: 979
Hi,

In the below statement..

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

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

REgards
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

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

Thanks,
Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
jQuery in Action, 2nd edition
 
subject: Cursor doubt in callable statement...