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;

DBMS

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;

PL SQL Program For function using exception.

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

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;