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

if you are using a prewritten script use set termout off at the start of the command you wish to blank and set termout on for the command you wish to see. This doesn't work when issued interactively which was what I thought you were after.

eg

set termout off
drop table niall_test;
create table niall_test;
drop table niall_test;
set termout on
drop table niall_test;
create table niall_test;
drop table niall_test;

--
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.0205170055.50fdb376_at_posting.google.com...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:<3ce3b98d$0$8506$ed9e5944_at_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.

>
> Hi Niall,
>
> thanks for the reply.
> Yes I would definitely want to know if the creates failed and why but
> was hoping to group all the drop statements at the beginning of the
> script and suppress the error messages for the drop statements only.
> I.e. turn off error messaging while executing the drop statements and
> then turn it back on for the create statements.
>
> Thanks,
> Mark.