Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlplus is showing output on stdout

mohitanchliaAug 28 2008 — edited Aug 29 2008
I have following "set" before running a query:

set serverout off term off echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on;
spool val.dat;
set timing on;
select * from abc
spool off
set echo on newpage 0 space 0 pagesize 0 feed on ;


When I run the script I get the output in val.dat and also on stdout. How can I turn off the output to stdout. I have tried the above options to try to turn it off, but nothing works
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2008
Added on Aug 28 2008
17 comments
12,682 views