SQL-Script arguments problem

From: F.Grossheim <f.grossheim_at_gmx.de>
Date: Wed, 19 Dec 2001 18:29:02 +0100
Message-ID: <9vqcf3$o97$1_at_newsfeed.nordcom.net>



Hi,

i call a sqlscipt with arguments in sqplus (unix). I start sqlplus with option -S[ilent]. The result of the query is written in a textfile: sqlplus -S username/password _at_script.sql 01.07.2001 01.08.2001 > textfile

content of script.sql:
select * from emp where hiredate between '&1' and '&2';

The problem is that not only the result of the query was written in the textfile.
The following text was also written at the beginning at the textfile:

old 30: where hiredate between '&1' and '&2' new 30: where hiredate between '01.07.2001' and '01.08.2001'

How can i avoid this! I want that only the results of my query are standing in the textfile. Received on Wed Dec 19 2001 - 18:29:02 CET

Original text of this message