Re: Hide Oracle error messages

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Fri, 29 May 1998 14:37:44 -0400
Message-ID: <6kmv9m$5nt@sjx-ixn6.ix.netcom.com>

Karina,
Put a SET TERMOUT OFF right before your DROP statements and put SET TERMOUT ON immediately after the DROP statements. That should do it.

Venkat

>
>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?
>
>Karina
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri May 29 1998 - 13:37:44 CDT