Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Function w/o RETURN clause
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: 0xA62A4849Received on Mon Oct 03 2005 - 20:05:52 CDT
![]() |
![]() |