Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Function Return And Raising Exception...
"R Chin" <rchin_at_panix.com> wrote in message
news:adrc1l$hjh$2_at_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
>
>
>
>
>
>
Hth
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Fri Jun 07 2002 - 23:59:29 CDT