RE: non existing tables in packages

Stephane,

certainly nothing that makes coding easier ;-)

> Frank <

-----Original Message-----
From: Stephane Faroult [mailto:sfaroult_at_roughsea.com] Subject: Re: non existing tables in packages

Frank,

   If you code the table name in the package, it will simply not compile. The only thing you can do IMHO is to use dynamic SQL and trap ORA-00942. HTH, Stephane Faroult

RoughSea Ltd
http://www.roughsea.com

Foelz.Frank wrote:

>Gentlemen,
>
>any idea, how to handle situations in a package when a table which is
>expected in subroutines is not present ? Is there any error handling
>available, which I am not aware of ?
>
>I would like to have the same package on each of our systems installed,
>even if certain tables are not present due to different software
>releases.
>
>Running on Oracle 9.2.n
>
>
>
>>Frank <
>>
>>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l