Ken Naim wrote: >Did you look into the whenever error clause for sql plus? > >-----Original Message----- >From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] >On Behalf Of Remigiusz Sokolowski >Sent: Wednesday, November 08, 2006 6:54 AM >To: oracle-l@xxxxxxxxxxxxx >Subject: sqlplus and error stream > >Hi! >I wonder if is there in sqlplus a possibility to turn error output off? >Or stream it to some place other than stdout or file used for spooling? >And I mean all errors, not only sqlplus errors > >The reason behind it is to produce clean scripts of course ... > > >Regards >Remigiusz > > > Well, I think that "whenever [..]error" clauses are about actions taken in case of error, but not about reporting it to user i.e. me. Any way it does not suppress the error messages from displaying/spooling to the file Regards Remigiusz -- --------------------------------------- Remigiusz Sokolowski <rems@xxxxxxxx> WP/PTI/DIP/ZAB (+04858) 52 15 770 MySQL v. 4.x Oracle v. 10.x --------------------------------------- -- //www.freelists.org/webpage/oracle-l