The stored procedure (or function) needs to return a REF_CURSOR.
Here's an example (very contrived) of the Java code:
Connection conn = getConnection(); // get connection from somewhere ( a pool
maybe ).
Callable statement = conn.prepareCall("{? = call someProc }");
statement.registerOutParameter(1);
statement.execute();
ResultSet rs = statement.getObject(1,OracleTypes.CURSOR);
Hope this helps!
--John
-----Original Message-----
From: Timlin, Bob [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 11:08 AM
To: '[EMAIL PROTECTED]'
Subject: Returning a Resultset from an Oracle Stored Procedure
Can anyone give me a reference to where I can get some detail information on
returning a resultset from an Oracle Stored Procedure to a JSP program? I
have found many samples of how to do this on the JSP side, but no
information on how to write a Oracle Stored Procedure that returns a
Resultset.
Thanks!
Bob Timlin
Senior Software Engineer
C.P.M.C Information Technology
415-600-7005
[EMAIL PROTECTED]
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
