PL/SQL Table may not be there

From: <mburgess_at_dedata.com.au>
Date: Thu, 04 Feb 1999 12:31:24 GMT
Message-ID: <79c3ut$cht$1@nnrp1.dejanews.com>

I am writing a function/package function which references a table which may not be there, it resides in a separate schema. If it doesn't exist then I want to trap the exception and return a value. We only want to maintain one code set and I while I could create a dummy view to substitute for the table I would rather not.

I have tried using the dbms_sql package but Oracle doesn't believe me when I use the pragma to assure it that I am not updating the database.

Oracle 7.3.4

Any Ideas?

Thanks

Michael Burgess

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 06:31:24 CST