Can someone please tell me what I am doing wrong. I can't get it to
suppress the command echo in the spool file or suppress the terminal output.
I'm sure it's something dumb, but I've been struggling for hours on this and
need help.


================================================== ============
$ cat test.scr
sqlplus user/pass@service <<SCRIPT
set echo off
set termout off
spool test.out
set trimspool on
set echo off
select sysdate from dual;
spool off
SCRIPT

================================================== ============
$ ./test.scr

SQL*Plus: Release 8.1.7.0.0 - Production on Sun May 22 03:20:57 2005

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production

SQL> SQL> SQL> SQL> SQL> SQL>
SYSDATE
---------
22-MAY-05

SQL> SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.1 -
Prod
uction
JServer Release 8.1.7.4.1 - Production

================================================== ==============
$ cat test.out
SQL> set trimspool on
SQL> set echo off
SQL> select sysdate from dual;

SYSDATE
---------
22-MAY-05

SQL> spool off

On Sun, 22 May 2005 07:27:11 GMT, "Randy Harris" <randy (AT) SpamFree (DOT) com>
wrote:

sqlplus -s .... etc

IIRC this is in the manual.


--
Sybrand Bakker, Senior Oracle DBA