Exception Handling

[Bart Pietercil]

Hi List, Ruslan,


In an exception block within a stored procedure can I do this:
begin


exception
when 56503 then
	leave
when others then
	print 'Error has occured: procedurename: ' || err_name


end

the question is about the err_name; can I use err_name to have  
description of the exception (ie: ERR_CONSTRAINT_UNIQUE_VIOLATION) ?

This way we could use the log to correct untrapped exceptions in an SP

tia

Bart Pietercil