How do I suppress the echo

From: Randy Harris <randy_at_SpamFree.com>
Date: Sun, 22 May 2005 07:27:11 GMT
Message-ID: <jvWje.3839$VS6.887@newssvr19.news.prodigy.com>

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_at_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 Received on Sun May 22 2005 - 02:27:11 CDT