wood burning stoves*
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "StoredProcedure" Watch "StoredProcedure" New topic
Author

StoredProcedure

kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1371
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
Bartender

Joined: Apr 14, 2004
Posts: 10336

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


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

Originally posted by Paul Sturrock:
Read the JavaDocs.


http://java.sun.com/j2se/1.4.2/docs/api/java/sql/CallableStatement.html


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

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...
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: StoredProcedure
 
Similar Threads
XMLType column with Spring
Spring StoredProcedure - How to Set Timeout for StoredProcedure call
Callabe Statement Return Values
How to return resultset from stored procdure
Calling Stored Procedures from EJB