Re: Hide Oracle error messages

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: Sat, 30 May 1998 10:54:44 GMT
Message-ID: <356fe101.10584507@read.news.global.net.uk>

On Fri, 29 May 1998 15:51:31 GMT, kchami_at_my-dejanews.com wrote:

>Is there any way to hide ORA-.. error messages?
>
>I have a batch installation script that runs into SQL*Plus and generates
>"normal" error messages, for example, when I drop and index before creating
>it, just to check if it is not already there.
>Therefore, the users running the script see these messages and are not able to
>make the difference between "normal" error messages and "abnormal" ones!
>I would like to be able not to display the foreseeable error messages in the
>log. How can I do that?
>

Interestingly, oracle don't bother doing this, so if you use the database creation wizard on NT you get a 5MB (137000 lines) log file that you're supposed to check manually for 'unexpected' errors.

The easiest way to suppress these messages is probably to wrap your drop statements in an anonymous pl/sql block using dbms_sql to issue the ddl and catching all exceptions with a null exception handler. Received on Sat May 30 1998 - 05:54:44 CDT