Re: Oracle ORA-00942 message gives no table name

From: Aleksey Burdakov <burdakov_at_vesco.ru>
Date: 21 Jan 2002 06:14:47 -0800
Message-ID: <9292180b.0201210614.5b92756a@posting.google.com>

Ok, is that possible to get this extra-information via ODBC or OCI interface ? If yes, then how to do this ?

Best Refards,

Aleksey Burdakov

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3c4843ae$0$237$ed9e5944_at_reading.news.pipex.net>...
> "Aleksey Burdakov" <burdakov_at_vesco.ru> wrote in message
> news:9292180b.0201180424.3b7594d8_at_posting.google.com...
> > Is that true that there is no way to get table/view name for ORA-00942
> > error from Oracle DBMS ?
>
> No. Sqlplus will note this bad tablename with an asterisk.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the

> likelihood of a good answer
>
> ******************************************
Received on Mon Jan 21 2002 - 08:14:47 CST