Re: SQL-Script with arguments problem

at top of script :
SET VERIFY OFF "F.Grossheim" wrote:

> 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 @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.