jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "Error in jdbc while executing procedure" Watch "Error in jdbc while executing procedure" New topic
Author

Error in jdbc while executing procedure

Skanda Raman
Ranch Hand

Joined: Mar 21, 2008
Posts: 205


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
Bartender

Joined: Dec 20, 2006
Posts: 2543
    
  10

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Error in jdbc while executing procedure
 
jQuery in Action, 3rd edition