Preprocessor

[aotte]

Hi,

Are there any plans for a PL/SQL preprocessor?

 

[orca777]

Hi,
at our customer site we use SQL*PLUS Vars
in PL/SQL-Code to generate the code in different db environments, sure you have no #if /#else like C++

carl

 

[Marco Kalter]

We do have plans for substitution variable support. This will ensure compatibility with SQL*Plus or other tools that you may be using for delivery or deployment.

 

[aotte]

Sounds good. Can anybody share an example on using substitution variables for preprocessing?

I'm just starting to look into this stuff, and a small boost would be appreciated...

Thanks.

 

[patch]

Maybe you could check out the installer for OUnit. This uses 'command-line parameters' in the script.
Also, the utPL/SQL codebase uses variable substitution to enable of disable certain parts of the code. For instance 9i code when deploying on an 8i database is disabled.

Regards,
Patrick

 

[aotte]

Thanks Patrick, will have a look, and start playing around with it.