How to return resultset from stored procdure

[ven]

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
ven

[darsh lak]

Use refcursor to return a cursor from storedprocedure
then use getObject(i) and typecast to Resutset
this should solve ur problem

[A Agrawal]

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";
cstmt.setInt(1,eid);
cstmt.setString(2,code);
cstmt.registerOutParameter(3,OracleTypes.CURSOR);
intRetVal = cstmt.executeUpdate();
rs=(ResultSet)cstmt.getObject(3);


------------------
Amit Agrawal,
New Delhi, India.

[Frank Carver]

"ven",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . 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.
Thanks.