trapping exception ORA-00942

From: Raymond van Daelen <daelen_at_wxs.nl>
Date: Tue, 31 Jul 2001 23:18:47 +0200
Message-ID: <3B6720B6.BCD95B7B@wxs.nl>

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 Received on Tue Jul 31 2001 - 16:18:47 CDT