Re: Returning a result set from a stored procedure

"Mike Krolewski" <mkrolewski_at_rii.com> wrote in message news:95vf7o$p2q$1_at_nnrp1.deja.com...
> In article <3A83078E.68A335FB_at_earthlink.net>,
> Tom Waterhouse <tomwater2_at_earthlink.net> wrote:
> > Oracle novice here, so please excuse the question.
> >
> > Is there a way to return a result set from a stored procedure? That
 is,
> > if I wanted a stored procedure to return a result set, and then be
 able
> > to have access to that result set via JDBC (just like a select
> > statement), what can I do?
> >
> > Thanks,
> >
> > Tom
> >
> >
>
> No. No and No. Oracle does not generate a result set. Ever.
>
> If you read the JDBC Developer's Guide and Reference Release 2.0,
> Chapter 11 speaks to the process of generating within Java a result
> set. Basically you need to develop the appropriate code. If done
> properly, you can have a scollable, updatable result set.
>
> Sorry for this short tirade. However, if you are a novice, you need to
> actually read alot. Oracle has many features and some limitations. You
> should be aware of them long before you start writing code. Knowing
> that Oracle does not generate a result set is practically the first day
> of school. Get some good books and start reading.
>
>
> --
> Michael Krolewski
> Rosetta Inpharmatics
> mkrolewski_at_rii.com
> Usual disclaimers
>
>
> Sent via Deja.com
> http://www.deja.com/

Knowing that Oracle *is* capable of creating a resultset is first day knowledge. Please stop distributing this misleading information.

Regards,

Sybrand Bakker, Oracle DBA Received on Fri Feb 09 2001 - 02:04:39 CST