You can do it using Oracle's REF cursor in packages(if you have Oracle 8i or newer). Idea is to create package, define ref cursor and define the procedure to use that ref cursor (in the package). Then you call package.procedurename(parameters) with JDBC and so on.
The best documentation you can found is at Oracle web site(or with your Oracle installation(Oracle8i JDBC Developer's Guide and Reference)). But you have to register yourself to the Oracle's Technology network to be able to view the docs online at Oracle. Here is link to the Oracle8i JDBC Developer's Guide and Reference at Oracle's site: http://otn.oracle.com/doc/java.815/a64685/toc.htm Teemu Keiski Application analyst, programmer Mansoft tietotekniikka Oy Finland -----Alkuperainen viesti----- Lahettaja: Timlin, Bob [mailto:[EMAIL PROTECTED]] Lahetetty: 21. joulukuuta 2001 21:08 Vastaanottaja: '[EMAIL PROTECTED]' Aihe: 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]>
