wood burning stoves 2.0*
The moose likes JDBC and the fly likes Error in jdbc while executing procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error in jdbc while executing procedure" Watch "Error in jdbc while executing procedure" New topic

Error in jdbc while executing procedure

Eshwar Prasad
Ranch Hand

Joined: Mar 21, 2008
Posts: 202

I have written a procedure with OUT parameter as below.

Although the procedure is compiled i am getting the message "Cursor closed" in my JSP page while executing. Please let me know how to use the cursor that is declared as OUT parameter in this procedure.

Jan Cumps

Joined: Dec 20, 2006
Posts: 2491

I think you have already traversed the complete cursor inside your pl/sql block, before you return the control to Java.
Have you tried any of the available tutorials on this topic first?

Regards, Jan

OCUP UML fundamental and ITIL foundation
youtube channel
It is sorta covered in the JavaRanch Style Guide.
subject: Error in jdbc while executing procedure
Similar Threads
Help required on Stored Procedure
What am i doing wrong here? ( Stored Procedure REF CURSOR Problem)
Error :java.sql.SQLException: Invalid column index
low performance of resultSet.next()
Varchar & Varchar2 in Stored procedure