RE: SUPPRESS SQL STATEMENTS

> -----Original Message-----
> Johan Muller
>
> A script dumps out table info. (sqlplus on aix 4.3.3 and
> oracle 8.1.7).
>
> I cannot suppress the PROMPT>@path/scriptname and
> PROMPT> spool off statements from the report output.
>
> The script contains both set heading off and set feedback
> off as part of the formatting.
>
> Posssible solutions?

I'm not sure if this is answers your question, but is this the output you're looking for?

# cat x.ksh
sqlplus /nolog @x.sql
# cat x.sql
set echo off
connect username/password
spool x.lst
select dummy from dual ;
spool off
exit
# x.ksh
SQL*Plus: Release 9.2.0.3.0 - Production on Tue Oct 14 11:51:35 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected.
D
-
X
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production
# cat x.lst

D                                                                               
-                                                                               
X                                                                               

#

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).