RE: non existing tables in packages

  • From: "Foelz.Frank" <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>
  • To: Oracle Mailing List <ORACLE-L@xxxxxxxxxxxxx>
  • Date: Tue, 13 Sep 2005 09:30:46 +0200


certainly nothing that makes coding easier ;-)

> Frank <

-----Original Message-----
From: Stephane Faroult [mailto:sfaroult@xxxxxxxxxxxx] 
Subject: Re: non existing tables in packages


   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 


Stephane Faroult

RoughSea Ltd

Foelz.Frank wrote:

>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 
>Running on Oracle 9.2.n
>>Frank <


Other related posts: