spool file help

[umeman]

DBA's

Is there a way to spool the output of multiple queries
to a spool file without the query being sent to the spool
file. I have tried

set feedback off
set echo off

However the query still gets sent to the spool file

e.g

sql> set feedback off;

sql> set echo off;

sql> spool c:\test.out

sql> select * from emp;

sql> select * from sal;

sql> spool off

I do not want the 2 select statements in the spool file.

Any help appreciated

Thanks
-u-

 

[rcurva]

SET VERIFY OFF
SET SHOW OFF
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[sem]

You need
SET SERVEROUT OFF
Another useful options are:
SET VERIFY OFF - if using lexical variables (&)
SET TERMOUT OFF - to prevent screen output