Passing values to Nested Cursors (possible?)

Greetings All,

Is it possible to pass a value from a fetched Cursor (A1) and send it to a nested cursor (A2)?

If so, how could it be done.

I've tried:

DECLARE
var1 NUMER;
var2 varchar(50);
varX varchar(50);

CURSOR A1 IS
SELECT id,Name FROM emp WHERE sal > 10000; BEGIN
OPEN A1;
LOOP
FETCH A1 INTO var1,var2;
EXIT WHEN A1%NOTFOUND;
/* nested */

  CURSOR A2 IS
  SELECT profile FROM emp_preference WHERE id = var1;   BEGIN
  OPEN A2;
  LOOP
  FETCH A2 INTO varX;
  EXIT WHEN A2%NOTFOUND;
  PRINT var1 ,var2, varX /* print the reuslt from cursor A1 and A2 */   END LOOP;
  END;
/* nested end*/

END LOOP;
END; As a newbie, any help would surely be appreciated. Thank you for your time.
J. Received on Fri Dec 21 2001 - 04:56:23 CET