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


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
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: 42584
    
  65
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can we call a stored procedure from java file