aspose file tools*
The moose likes Websphere and the fly likes How can we call a stored procedure from java file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "How can we call a stored procedure from java file" Watch "How can we call a stored procedure from java file" New topic
Author

How can we call a stored procedure from java file

kiranbabu chinthaa
Greenhorn

Joined: Jul 25, 2009
Posts: 5
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.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41865
    
  63
Here's what a search through the JDBC forum finds for the term "calling oracle stored procedure".


Ping & DNS - my free Android networking tools app
Vicki Amin
Ranch Hand

Joined: Aug 31, 2005
Posts: 32
Try this



SCJP 1.4 | SCWCD 1.3 | SCBCD 1.4 | Oracle 9i:SQL | TOGAF 9
kiranbabu chinthaa
Greenhorn

Joined: Jul 25, 2009
Posts: 5
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....
Vicki Amin
Ranch Hand

Joined: Aug 31, 2005
Posts: 32


kiranbabu chinthaa
Greenhorn

Joined: Jul 25, 2009
Posts: 5
Thank you vicki, i hope this will work fine for me.
 
jQuery in Action, 2nd edition
 
subject: How can we call a stored procedure from java file