Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Conditional Compilation in Oracle 10g Database Release 2 - Use conditional compilation to alter the contents of your PL/SQL source code based on compiler directives.



Catalina said...

$IF DBMS_DB_VERSION.VER_LE_10_1 $THEN...this won't compile on version < 10, so I guess this example don't make much sense..altought article is useful

Tim... said...

Hi.

Conditional compilation was only introduced in 10g, so the whole thing will fail to compile in 9i.

The point is, if the version is 10gR1 you do one thing, if it's 10gR2 you do another. This code is not catering for pre-10g.

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired