File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes StoredProcedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "StoredProcedure" Watch "StoredProcedure" New topic


kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1428
My StoredProcedure located on the Oracle DB. It has select statement.
I want to call this StoredProcedure thru my java code and form the ResultSet. How can i do that?
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

With a java.sql.CallableStatement. Read the JavaDocs.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Ben Souther

Joined: Dec 11, 2004
Posts: 13410

Originally posted by Paul Sturrock:
Read the JavaDocs.

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Thank you Ben.

I wonder if this will happen everytime I can't be bothered posting a URL? I could get very lazy...
I agree. Here's the link:
subject: StoredProcedure
jQuery in Action, 3rd edition