Re: Call a cursor in another

ind_123 wrote:
> I have an Oracle procedure in which I am calling a select statement. I
> need to use the results of this select statment and do something and
> form another select statement.
>
> select a, b, c ....
>
> I need to use a, b, c to do something to get
> d, e, f
>
> I need to make another select as
> select d, e,f ..
> use it in a report.
>
> How can I do this?

Native Dynamic SQL

Go to Morgan's Library at www.psoug.org and scroll down until you find the link to the demos.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org