Re: non existing tables in packages

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: Foelz.Frank@xxxxxxxxxxxxxxxxxxx
  • Date: Tue, 13 Sep 2005 09:26:10 +0200

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 <


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




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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2005