Re: PLSQL code and different ORACLE versions

From: Chris Weiss <weisschr_at_tcimet.net>
Date: Fri, 13 Jul 2001 15:06:22 -0400
Message-ID: <9ingh6$221c$1@msunews.cl.msu.edu>

You can use C-preprocessor and macros to expand your code into version specific files. This allows you to add and remove debug code, add or remove version specific code, or cull out queries into stand alone test versions.

Good luck,
Chris Weiss

"Steffen Nicolai" <nci_at_ast.iitb.fhg.de> wrote in message news:3B4E94AB.672AAFB9_at_ast.iitb.fhg.de...
> Hi,
>
> is there a way to develop PLSQL code for different ORACLE version and
> switch them during compile time (like #IFDEF preprocessor directives in
> C). One example is to use the FORALL statement in version 8.1.7 and the
> FOR ... LOOP in 8.0.5.
>
> TIA
>
> Nico
> --
> Steffen Nicolai
> Fraunhofer Anwendungszentrum Systemtechnik
> Ilmenau / Germany
> Tel: +49 3677 / 669 4012 | Fax: +49 3677 / 669 4001
> e-mail: Nci_at_ast.iitb.fhg.de
Received on Fri Jul 13 2001 - 14:06:22 CDT