Re: Help with CURSOR question, please?
From: info <info_at_stoas.nl>
Date: Tue, 28 Jul 1998 10:34:00 +0200
Message-ID: <35BD8CF8.FA8D8045_at_stoas.nl>
Date: Tue, 28 Jul 1998 10:34:00 +0200
Message-ID: <35BD8CF8.FA8D8045_at_stoas.nl>
Hi,
While you fetch cur1 into cur1_rec, you can use the value of cur1_rec.a in your where statement
CURSOR cur2
IS
SELECT e, f
where e = cur1_rec.a
FROM b
ORDER BY e, f ASC;
This should work.
Henk Hultink
Stoas Wageningen
"Activating Knowledge"
Received on Tue Jul 28 1998 - 10:34:00 CEST