Re: How to return a result set from a stored proc?

Thomas, thank you for including the link to your page, that was very very helpful.
I have a further question in this vien.
I am coming from ms sql, where using the stored procedures gives you an edge bcs of the pre-compiling and everything.

From what I am learning about Oracle, this may not be necesary, bcs Oracle stores recent queries and popular records/tables in memorY?

What gains do you see in using stored procs/functions in this way? I found a way
to use a IN/OUT parameterwith a proc, haven't run the proc yet but it compiled,
what do you think of that???

Thanks.
Whatleigh

> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries
> http://osi.oracle.com/~tkyte/index.html
> --
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon May 15 2000 - 00:00:00 CDT