Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: trapping exception ORA-00942
On Tue, 31 Jul 2001, daelen_at_wxs.nl wrote:
> Hello,
>
> the search for which table or view "does not exist" can
> sometimes be painfull.
>
> Therefore we would like to make the Oracle exception:
> "ORA-00942: table or view does not exist" somewhat more
> meaningfull, ic to get an idea about which table or view is
> actually not found!
>
> Our idea was first to trap the excpetion by a trigger which
> fires after an servererror, followed by identifying the last
> excuted sql statement. The problem was getting the actual
> statement causing the error message.
>
> Anyone any idea how to solve this?
>
> Any suggestions welcome.
>
> Raymond
-- Galen Boyer It seems to me, I remember every single thing I know.Received on Wed Aug 29 2001 - 21:29:17 CDT