rtc using exception

declare
origin1 varchar2(10);
ticketno number(4);
e1 number(10):=&e1;
chen exception;
ban exception;
begin
select origin,ticket_no into origin1,ticketno from tick_header where ticket_no =e1;
if origin1='chennai' then
raise chen;
elsif origin1='banglore' then
raise ban;
end if;
exception
when chen then
dbms_output.put_line(origin1||' '||ticketno);
when ban then
dbms_output.put_line(origin1||' '||ticketno);
end;
/

No comments:

Post a Comment

Template Design by faris vio