Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Tue Sep 13 2005 - 02:28:10 CDT
![]() |
![]() |