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 pass a cursor between databases Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "pass a cursor between databases" Watch "pass a cursor between databases" New topic

pass a cursor between databases

meera rao
Ranch Hand

Joined: Jun 30, 2005
Posts: 67
I have stored procedure , which calls another stored procedure in another database which has a cursor as an OUT parameter.

How can I access this cursor in my first procedure.

( I can execute the procedure but it says cursor has to be opened)
I agree. Here's the link:
subject: pass a cursor between databases
jQuery in Action, 3rd edition