CAn anybody please help me? I have to do this exercise with NO_DATA_FOUND but is not working.
ThiS one works great (EXIT WHEN NOTFOUND!!) but my exercise has to user NOT_DATA_FOUND! like the one at the END but is NOT WORKING, please little help?
SET SERVEROUTPUT ON
CURSOR c_employee IS
WHERE State = 'Delaware';
FETCH c_employee INTO v_emp_id, v_firstname,v_lastname ;
EXIT WHEN c_employee%NOTFOUND;
INSERT INTO temp_table (id_temp, firstname_temp,lastname_temp)
VALUES (v_emp_id, v_firstname,v_lastname);