Hi
I have written the code like this...But I am not getting when no data found exeception...please advise..!!!!
create or replace procedure dis_emp(v_empno in number) as
cursor kk is select * from empl where empno=v_empno;
a kk%rowtype;
begin
open kk;
loop
fetch kk into a;
exit when kk%notfound;
dbms_output.put_line(a.empno||' '||a.ename||' '||a.job);
end loop;
close kk;
exception
when no_data_found then
dbms_output.put_line('Sorry...wrong empid');
when others then
dbms_output.put_line('sorry..');
end;
regards
SA