I believe I found information on returning result sets from procedures in Oracle on Oracle's site - check their FAQ. The problem in earlier versions was true regardless of language accessing the db. I believe the posted workaround was a VB program - basically it loaded the resultset into an array - very ugly. It's been a long time since I worked with Oracle or I'd be more specific. I do remember your frustration.
----- Original Message ----- From: "Timlin, Bob" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Friday, December 21, 2001 11:24 AM Subject: RE: Returning a Resultset from an Oracle Stored Procedure > I am using Oracle8i and am not sure where the Oracle documentation is. I > have several advanced Oracle books and none of them discuss it. Very > frustrating! How about doing the same thing, but from an Oracle Stored > Procedure to a Visual Basic program? > > > -----Original Message----- > > From: Robert Dunlop [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, December 21, 2001 11:25 AM > > To: Tomcat Users List > > Subject: Re: 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. > > > > > > > > Bob, > > > > You need to go to your Oracle documentation on this. And, depending > > on > > the version of Oracle this may be a problem. I don't think Oracle in > > versions prior to 8x supported returning result sets from stored procs. I > > know I've found some ugly work arounds when trying to do the same from C++ > > apps via ODBC. > > > > Bob > > > > > > > > > > -- > > 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]>
