This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "StoredProcedure" Watch "StoredProcedure" New topic


kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1404
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...
Consider Paul's rocket mass heater.
subject: StoredProcedure
It's not a secret anymore!