Does the REF Cursor get declared in the parameter list as an OUT parameter or in the Declaration sections as a variable? Thanks, Bob Timlin.
> -----Original Message----- > From: Teemu Keiski [SMTP:[EMAIL PROTECTED]] > Sent: Friday, December 21, 2001 11:29 AM > To: Tomcat Users List > Subject: VS: Returning a Resultset from an Oracle Stored Procedure > > 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]> > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
