Hi
How to trap the exception NO DATA FOUND/other exceptions with the cursor
DECLARE
CURSOR c1 IS SELECT * FROM EMP WHERE empno = 1234;
BEGIN
FOR i IN c1 LOOP
DBMS_OUTPUT.PUT_LINE(i.ename);
END LOOP;
END;
so 1234 is not in my table, how to trap this.could some one help me please
Edited by: user4587979 on Sep 27, 2010 3:46 AM