Function Return And Raising Exception...

From: R Chin <rchin_at_panix.com>
Date: Fri, 7 Jun 2002 18:31:51 -0400
Message-ID: <adrc1l$hjh$2@reader1.panix.com>

I need a confirmation please...

I have user defined EXCEPTION declared at pkg BODY level .eg
incorrect_value EXCEPTION;

If I raise this exception in a FUNCTION (THAT HAS NO EXCEPTION SECTION) then return the functions RETURN...

raise incorrect_value ;
return l_return_value;

Is this Correct:
1) This exception will propogate to the CALLER

(I want that and handle it in the caller) AND
2) I will ALSO get the value l_return_value in the caller

thanks
Robert Received on Fri Jun 07 2002 - 17:31:51 CDT