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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Function w/o RETURN clause

Re: Function w/o RETURN clause

From: Andy Hardy <junkmail_at_[127.0.0.1>
Date: Tue, 4 Oct 2005 02:05:52 +0100
Message-ID: <89zXBOCwVdQDFAzb@[127.0.0.1]>


In message <dhpgm0$g8q$1_at_reader1.panix.com> , Boobie <boobie.clj_at_mailnull.com> writes
>Since when can PL/SQL Function without RETURN be compilable ?
>I could swear not in 8i....

It's always been compilable AFAIK, certainly it is in 8i. At run-time you'll get an exception if you exit a function without the use of a RETURN. I guess that compiler doesn't report the absence as an error because it can't prove that any 'returns' it does see will actually be executed at run-time.

-- 
Andy Hardy. PGP ID: 0xA62A4849
Received on Mon Oct 03 2005 - 20:05:52 CDT

Original text of this message

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