Re: Conditional compiles in PL/SQL...?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 08 Dec 1999 19:11:06 +0800
Message-ID: <384E3CCA.53B5@yahoo.com>

bobdev_at_fc.hp.com wrote:
>
> 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!

Not trivially...

Maybe move the problem code into a separate proc and then conditionally call it...

..or move the offending code into dbms_sql

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Dec 08 1999 - 05:11:06 CST