wood burning stoves 2.0*
The moose likes JDBC and the fly likes Handling cursor declared in oracle in java program Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Handling cursor declared in oracle in java program" Watch "Handling cursor declared in oracle in java program" New topic
Author

Handling cursor declared in oracle in java program

minal silimkar
Ranch Hand

Joined: Nov 25, 2007
Posts: 133
I have created cursor in oracle which returns cursor. I want to handle cursor specified below in java. I tried java code given below shows error







[ September 12, 2008: Message edited by: minal silimkar ]

Minal Silimkar
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Its long time when I worked on cursors but I did not create a cursor type as you created.

I have modified your procedure code, in this you need not to populate your out variable.

you can try this, hope this will work






Thanks,
Shailesh
[ September 10, 2008: Message edited by: Shailesh Chandra ]

Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
minal silimkar
Ranch Hand

Joined: Nov 25, 2007
Posts: 133
Thanks Shailesh, for your reply.
But I want to handle that out parameter which is returning cursor, in java program. How can I do that?
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Originally posted by minal silimkar:

But I want to handle that out parameter which is returning cursor, in java program. How can I do that?


This is same what you want, you need NOT to do any change in your java program. change only stored procedure part and run same java program and let us know what is output.

Thanks,
Shailesh
[ September 12, 2008: Message edited by: Shailesh Chandra ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Handling cursor declared in oracle in java program