Remigiusz Sokołowski wrote:
>Michael Fontana wrote:
>
>
>
>>try this:
>>
>>sqlplus > set feedback off veri off
>>
>>
>>
>>
>>
>>
>Hi!
>It is not enough. Feedback turns on/off some additional information on
>sql success.
>Echo turns off/on sql statement repetition.
>However let's assume we have a sql which failed - server returns some
>message
>about failure, which is displayed - I do not know, how to avoid it.
>That is why I name it an "error stream" - by analogy to stderr - of
>course in sqlplus there could be no such mechanism
>
>Best regards
>Remigiusz
>
>
>
>
ups, I replace verify with echo, but verify also is not enough - it
turns off repetition of sql with variables replaced by their values
--
---------------------------------------
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
Received on Thu Nov 09 2006 - 03:57:50 CST
