Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How can we call a stored procedure from java file

 
kiranbabu chinthaa
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here's what a search through the JDBC forum finds for the term "calling oracle stored procedure".
 
Vicki Amin
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try this

 
kiranbabu chinthaa
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


 
kiranbabu chinthaa
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you vicki, i hope this will work fine for me.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic