by I have two blocks on a form and each block is a separate table. I want to
be able to leave a field called "EI_SN" and populate the multi-record block
with values from another table. I used the following cursor. I retrieves the
last record only. The following is the cursor I used. I tried next_record
and it doesn't work either.
Please help!!!! - Urgent!
DECLARE
CURSOR LOOPTEST IS
SELECT PN, NSN, NOUN FROM MCDS_TEST1 WHERE EI_SN = :MCDS_TEST2.EI_SN;
BEGIN
OPEN LOOPTEST;
LOOP
FETCH LOOPTEST INTO :MCDS_CCCO.PN, :NSN, :NOUN;
EXIT WHEN LOOPTEST %NOTFOUND;
END LOOP;
CLOSE LOOPTEST;
END;
Thanks.... I have tried everything!!!!
Jean