Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Handle and compile PL/SQL code if a table does not exist.

aragorn1972Jun 18 2014 — edited Jun 18 2014

Hello everyone.

I have the following problem:

Some of my customers do not have certain tables created on their databases (they haven't bought the module), but i have a package that refers to these tables (among many others things).

Is there a way that i can instruct the oracle compiler not to evaluate some parts of code if the tables do not exist?

Since the projects were created years ago and there is a lot of legacy code written all of it in one package, i cannot break the package in parts and install every module-part on my clients. If i get forced to do that, i will more or less have to write the whole thing again.

Thanks in advance!

Thanassis

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2014
Added on Jun 18 2014
4 comments
1,191 views