PL SQL Program For function using exception.

PL SQL Program For function using exception.


create or replace function stinfo(no in number) return varchar2 is snam varchar2(30);
begin
select name into snam from student where stuid=no;
return snam;
exception 
when no_data_found then
return(' Record does not exist ');
end;