RE: non existing tables in packages

Stephane,

certainly nothing that makes coding easier ;-)

> Frank <

-----Original Message-----
From: Stephane Faroult [mailto:sfaroult@xxxxxxxxxxxx] 
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

Other related posts: