The moose likes JDBC and the fly likes Stored Procedures Returning a Cursor Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JDBC
Reply Bookmark "Stored Procedures Returning a Cursor" Watch "Stored Procedures Returning a Cursor" New topic
Author

Stored Procedures Returning a Cursor

yogesh somavanshi
Greenhorn

Joined: Jan 11, 2002
Posts: 6
Hello all,
My stored procedure returns a Cursor type , so how to recieve the Cursor type into Java ResultSet (I had gone thro the java.sql doc but failed to find the Types.ResultSet type).
So which is the required package for returning the ResultSet.
I was trying with OracleDriver but did not have enough details.
So will u please send me the details of the specific(dll or jar file ) which oracle supports for returning a Cursor into a ResultSEt.
Regards
Yogesh
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
yogesh
Welcome to the Java Ranch, we hope you’ll enjoy visiting as a regular however,
your name is not in keeping with our naming policy here at the ranch. Please change your display name to an appropriate name as shown in the policy.
Thanks again and we hope to see you around the ranch!!


Dave
 
 
subject: Stored Procedures Returning a Cursor
 
Threads others viewed
Adv JDBC ?
what is real world uses of cursors?
Reading nested oracle cursors getCursor(col) throws ORA-01002 "Fetch out of sequence"
cursor?
Resultset returned by stored proc not forward only
IntelliJ Java IDE