Re: PL/SQL exceptions for missing table?

From: <joseph_testa_at_aep.com>
Date: Tue, 05 May 1998 10:50:39 -0600
Message-ID: <6incgf$i4t$1@nnrp1.dejanews.com>

If you are talking about a db table(not a pl/sql table), trap for a ORA-00942(table or voew not found).

In article <rtmd30-0405981558340001_at_pangaea.sps.mot.com>#1/1, rtmd30_at_email.sps.mot.com (Greg Ferguson) wrote:
>
> Hi,
>
> I looked in the Oracle book, but didn't see an exception that'd be raised
> if I tried to do a select...into with a non-existing table.
>
> I'm trying to handle a case where my code is first run, and its private
> table hasn't been initialized.
>
> Is there a way to handle this condition?
>
> Thanks,
>
> Greg
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 05 1998 - 11:50:39 CDT