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

"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. Received on Fri May 17 2002 - 03:55:41 CDT