RE: removing SQL script from output

try in your batch script "sqlplus @C:\bin\script_imp.sql". The default is not to echo anything.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David cheyne Sent: Wednesday, August 24, 2005 6:17 AM To: oracle-l_at_freelists.org
Subject: removing SQL script from output

Okay, idiot level question I think.  

I have a script to run on windows as a batchfile:  

BATCHFILE:   sqlplus <C:\bin\script_imp.sql    

SCRIPT
script_imp.sql  

username/password_at_instance
set pagesize 0
set linesize 500
set head off
set verify off
set termout off
set feedback off
spool C:\bin\an_outputfile_imp.csv  

<SQL statement>  

spool off;    

The problem is that the SQL is always shown at the top of the file!!  

Thanks!    

-- 
~~~~~~~~~~~~~~~~~~~~~~~
David Cheyne
BA(hons.)

Oracle Database Administrator

 

--
http://www.freelists.org/webpage/oracle-l