aspose file tools*
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
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: 2510
    
  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
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error in jdbc while executing procedure