From oracle-l-bounce@freelists.org Wed Aug 24 05:18:46 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7OAIkqn002699 for ; Wed, 24 Aug 2005 05:18:46 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j7OAIiIP002689 for ; Wed, 24 Aug 2005 05:18:44 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 50E551E6950; Wed, 24 Aug 2005 05:18:40 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23417-02; Wed, 24 Aug 2005 05:18:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CBEF21E693B; Wed, 24 Aug 2005 05:18:39 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=Z+YDXi/uxTYJCd1aztfTR3YBfNGawZ9URU0v8ILRCO+cC/Y++0nRzKq0wBasD4q/MIBCuB0eoFpi5vj8Z4Ky7rsMLB+0sojgczC690eKtW6HV7h+bPz9z6Aprybukt/450rtANaJtmxpBD0PHB8EGkBFbxCldLGeTRq35vc0Xus= Message-ID: <13efe57b05082403165db96c71@mail.gmail.com> Date: Wed, 24 Aug 2005 11:16:48 +0100 From: David cheyne To: oracle-l@freelists.org Subject: removing SQL script from output Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1330_19610530.1124878608521" X-archive-position: 24406 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: david.cheyne@gmail.com Precedence: normal Reply-To: david.cheyne@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.4 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_1330_19610530.1124878608521 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Okay, idiot level question I think. I have a script to run on windows as a batchfile: BATCHFILE: sqlplus spool off; The problem is that the SQL is always shown at the top of the file!! Thanks! =20 --=20 ~~~~~~~~~~~~~~~~~~~~~~~ David Cheyne BA(hons.) Oracle Database Administrator ------=_Part_1330_19610530.1124878608521 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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
 
set pagesize 0
set linesize 500
set head off=
set verify off
set termout off
set feedback off 
spool&n= bsp;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

 
------=_Part_1330_19610530.1124878608521-- -- http://www.freelists.org/webpage/oracle-l