• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Calling a Procedure from Oracle to java

I have made Some Procedure in oracle(8.0). Now I have connect this through Jdbc in my Java Application.Now < i can execute query through Prepared statemnt object but I am not able to call a procedure in Oracle through it. Tell me Is it Possible to call procedure through this object. If not then which way , I can call the procedures in my Java Application.

Thanks in advance.
0
vinay_krishna
Asked:
vinay_krishna
2 Solutions
 
guidwayCommented:
0
 
Venci75Commented:
CallableStatement stmt = connection.prepareCall("{call myProc(?,?)}");
stmt.setString(1, "p1");
stmt.setString(2, "p2");
stmt.execute();
0
 
CleanupPingCommented:
vinay_krishna:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
tomboshellCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
SPLIT between guidway and Venci75

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thomas Boshell
EE Cleanup Volunteer
0
 
vinay_krishnaAuthor Commented:
Now,
        I am Satisfied with the answers. I want to close this question
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now