This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
How can we call a stored procedure from java file.
I have a stored procedure in Oracle 10G, which is returning the data in a cursor, i need to fetch the data in the cursor and display the result in the java file,
can anybody help me out to give the complete procedure with steps to accomplish the same.
Thanks in advance.
Thanks for your reply Vicki, and coming to my requirement, i have one input parameter of type String and one output parameter of type CURSOR, could you please give me the complete steps to call that stored procedure from java code and fetch the data that is returned from the stored procedure through the cursor and getting each and every column from that returned cursor.
Thanks in advance....
Joined: Aug 31, 2005
Joined: Jul 25, 2009
Thank you vicki, i hope this will work fine for me.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: How can we call a stored procedure from java file