Raising Exceptions etc

[Philip Stevenson]

Hi,
how do you handle exceptions & exceptions in stored procedures/functions. Also can you user define exceptions and raise the user define exception.

I have included some oracle code, thanks in advance for any help

regards
phil


eg Oracle Code

declare
l_x number;

begin

select x into l_x
from abc

exception
when no_data_found then

insert into debug
select
'no_data_found'
,'this is an exception'
from dual;

commit;

raise;
end;

,