Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Function Return And Raising Exception...

Re: Function Return And Raising Exception...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 8 Jun 2002 06:59:29 +0200
Message-ID: <ads8qe$1ut7k$1@ID-62141.news.dfncis.de>

"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
>
>
>
>
>
>

  1. yes
  2. no

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Fri Jun 07 2002 - 23:59:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US