Re: sqlplus and error stream

Ken Naim wrote:

>Did you look into the whenever error clause for sql plus?
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
>On Behalf Of Remigiusz Sokolowski
>Sent: Wednesday, November 08, 2006 6:54 AM
>To: oracle-l_at_freelists.org
>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_at_wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL  v.  4.x
Oracle v. 10.x
---------------------------------------

--
http://www.freelists.org/webpage/oracle-l