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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Condition Compilation Question

Re: Condition Compilation Question

From: Ethan Post <post.ethan_at_gmail.com>
Date: Tue, 15 May 2007 11:54:28 -0500
Message-ID: <357b48a90705150954x2baeb407k168adb285cddf00@mail.gmail.com>


Quoted from the article.

"Note a very important difference here—you did not need to recompile the procedure;"

There are two examples in the article one in which you do have to recompile and one in which you don't. Assuming the example works as stated and thinking about this some more I am inclined to think that the "$if $else" code only executes when the package is loaded into memory for a given session. If the flag is changed in the other package then the other package is invalidated and must be revalidated again. I might have to create a couple test cases.

On 5/15/07, Brady, Mark <Mark.Brady_at_constellation.com> wrote:
>
> Conditional compilation eliminates sections from the compiled code
> entirely. If you flipped the debug_flag to TRUE, you 'd still be printing
> Debug=F until you recompiled your source code.
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 15 2007 - 11:54:28 CDT

Original text of this message

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