dear friends,
I want to have a generic Exception Handling in SP as Follows

begin

statements .... There may be any nested procs

statements .... There may be any nested procs

statements .... There may be any nested procs

when any do
begin

here I would like to have exception name, description
and nested proc name that has raised the exception
which I would like to store in a table and show
later when batch process is completed

end
end

is it possible to do this with firebird ?
if yes how can I achieve this ?

I am using d5->IBO->firebird SS on Linux server

Best Regards

R. S. Patil