Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Supress Display of Oracle Error Messages in SQL*PLus

Re: Supress Display of Oracle Error Messages in SQL*PLus

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 16 May 2002 14:52:13 +0100
Message-ID: <3ce3b98d$0$8506$ed9e5944@reading.news.pipex.net>


I'm unaware of any setting, but more seriously surely this is a mad request. You'd want to know if the Create failed wouldn't you!

--
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

******************************************
"Mark PAtterson" <m_patte_at_yahoo.com> wrote in message
news:4c08015.0205160547.ffed11f_at_posting.google.com...

> Hi,
>
> is it possible to stop Oracle error messages such as "ORA-00942: table
> or view does not exist" from appearing on the SQL*Plus screen or
> spooling to a file? I.e. is there a setting for error messages similar
> to setting feedback off and/or verify off?
>
> Placing the sql inside a PL/SQL block is not an option. Basically I
> have many numerous large scripts for installing the database
> components of a product. As with good practise I execute a "drop"
> statement before every "create" statement but I'd like not to display
> error messages resulting from the "drop" statement when the object in
> question does not already exist (i.e. first time the installer is
> run).
>
> Is there an easy option/setting?
>
> Thanks,
> Mark.
Received on Thu May 16 2002 - 08:52:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US