Re: Help with CURSOR question, please?

Make your second cursor parameterised and then add a where clause to it testing for it

something like
 CURSOR cur2 (varchar2 p_myvalue)
  IS
   SELECT e, f
   FROM b
  WHERE b.e = p_myvalue
   ORDER BY e, f ASC;

and then change your open statement for cursor 2 to be somethin like

OPEN curs (cur1.id);

--
Alan D. Mills

agibbons_at_erols.com wrote in message <6p7kmv$dmn$1_at_winter.news.erols.com>...
>Can you offer any suggestions please?

YEP
>
>I am trying to do the following:
>
>1. open cursor cur1 to retreive all a.id rows in table a
>2. for each a.id retreived from table a do the following:
> a) open cursor cur2 and retreive only those rows
> from table b where a.id = b.e
> b) write some text to a file
>
Received on Thu Jul 23 1998 - 10:47:37 CDT