my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes How  to  return  resultset  from stored procdure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How  to  return  resultset  from stored procdure" Watch "How  to  return  resultset  from stored procdure" New topic

How to return resultset from stored procdure


Joined: Jul 16, 2001
Posts: 1
Hi All,
My select statement in stored procedure returning multiple
rows. How can I call stored procedure from java using callable statement.
can any body give with simple example both java and sp.
Thanks in Advance
darsh lak

Joined: Jul 17, 2001
Posts: 1
Use refcursor to return a cursor from storedprocedure
then use getObject(i) and typecast to Resutset
this should solve ur problem
A Agrawal
Ranch Hand

Joined: Jul 13, 2001
Posts: 41
Assuming cstmt is your callable statement variable name and conn is your connection variable name...and GP_FETCH_EISCONTACTS is your stored procdure's name.
try this...
cstmt = conn.prepareCall("{call GP_FETCH_EISCONTACTS (?,?,?)}");
int eid = 599;
String code = "Amit";
intRetVal = cstmt.executeUpdate();

Amit Agrawal,
New Delhi, India.

Amit Agrawal,<BR>New Delhi, India.
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.

Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
I agree. Here's the link:
subject: How to return resultset from stored procdure
It's not a secret anymore!