RETURN and EXIT in WHEN block
blueoraDec 29 2009 — edited Dec 29 2009This is an excerpt from a 11g PL/SQL book.
The prototype for the WHEN block is
WHEN {predefined_exception | user_defined_exception | OTHERS} THEN
exception_handling_statement;
{RETURN | EXIT}
I've no clue what RETURN and EXIT do here. Can someone show the usage with some example code?
Thanks for your help.
--Rob