Exception handling, with multiple try, catch exception, try again
Marius2Jul 9 2008 — edited Jul 9 2008I'm trying to make a PL/SQL code that try something and if that fails try something different. I expect to have a few itterations of this. So far the bes I could come up with was
BEGIN
return some_function_that_might_throw_and_exception()
EXCEPTION
WHEN OTHERS THEN
BEGIN
return some_other_function_that_might_throw_and_exception()
EXCEPTION
WHEN OTHERS THEN
.
.
.
and so on.
I wondered if there is some neater way of doing this?