Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Supress Display of Oracle Error Messages in SQL*PLus
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...Received on Thu May 16 2002 - 08:52:13 CDT
> 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.
![]() |
![]() |