File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JDBC and stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "JDBC and stored procedure" Watch "JDBC and stored procedure" New topic
Author

JDBC and stored procedure

Shashi Iyy
Greenhorn

Joined: Jun 12, 2008
Posts: 18
Hi All,
I have a stored procedure which takes a String value as the input and returns a cursor object.I need to write JDBC code to access the stored procedure and act on the cursor object returned from the procedure.How to go about this?A example would be a better option.Thanks in advance.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 32675
    
    4
Read this and this.
 
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: JDBC and stored procedure
 
Similar Threads
how to call a stored procedure which return cursor
pass a cursor between databases
Java code to access a stored procedure
Storedprocedures returns cursor
Handling Cursors in JDBC programming