Hi,
Running the following:
DECLARE
var varchar2(2);
BEGIN
for var in 1..5 loop
CASE var
WHEN 1 THEN dbms_output.put_line('A : Excellent');
WHEN 2 THEN dbms_output.put_line('B : Good');
WHEN 3 THEN dbms_output.put_line('C : Satisfactory');
WHEN 4 THEN dbms_output.put_line('D : Minimal');
END CASE;
EXCEPTION
WHEN CASE_NOT_FOUND THEN
dbms_output.put_line('NOT SUCH CASE');
END LOOP;
END;
I have:
ORA-06550: line 13, column 1: PLS-00103: Encountered the symbol "EXCEPTION"
Where am I wrong in my code?
Thank you.