Re: Conditional define with PL/SQL

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 24 Jul 2006 02:07:37 -0700
Message-ID: <1153732057.490352.96160@i42g2000cwa.googlegroups.com>

InTheBeginning wrote:
> Hi
>
> Is it possible to have conditional define in pl/sql depending on Oracle
> version. ?
>
> for example:
>
> BEGIN
> ...
> IF_ORACLE_V9
> select ... from v$undostat
> ENDDEFINE;
>
> IF_ORACLE_V8
> NULL;
> ENDDEFINE ;
>
> ...
> END;
>
> Thank you
> Dan

Yes, conditional compilation is fully supported in 10g and can be enabled with a hidden parameter in 9.2 since 9.2.0.6. It's not available in previous releases though. For more information, check 10g PL/SQL docs at http://docs.oracle.com (redirects to OTN, which requires free registration.) There's also an article by Steven Feuerstein about this on OTN.

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Mon Jul 24 2006 - 04:07:37 CDT