This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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: 2549
    
  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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error in jdbc while executing procedure
 
It's not a secret anymore!