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 (See ORA-00942.ora-code.com).
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 > > >
