aspose file tools
The moose likes JDBC and the fly likes pass a cursor between databases Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "pass a cursor between databases" Watch "pass a cursor between databases" New topic
Author

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: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: pass a cursor between databases
 
Similar Threads
stored procedure inside another stored procedure
Java code to access a stored procedure
Calling Stored Procedure from Hibernate mapping file
Workarounds for Oracle Table, Row, Record, Boolean data types
Handling Cursors in JDBC programming