Conditional compiles in PL/SQL...?

From: <bobdev_at_fc.hp.com>
Date: 8 Dec 1999 18:24:19 GMT
Message-ID: <82m7oj$13o$1@fcnews.fc.hp.com>

I have a stored procedure (SP) which works fine on System A. My database on system B has a database which lacks a table that part of the SP references.

What I'd like to be able to do is bracket sections of the SP which are to be *ignored* on system B when I compile the SP into the database. Assume, of course, that the SP is syntactically correct in either case.

How do I do this? A good deal of surfing time has so far yielded no answer. Is there a #pragma or some sort of #define which lets me drop out sections of the SP at compile time?

Thanks! Received on Wed Dec 08 1999 - 12:24:19 CST