Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL-Script with arguments problem

SQL-Script with arguments problem

From: F.Grossheim <f.grossheim_at_gmx.de>
Date: Wed, 19 Dec 2001 18:28:31 +0100
Message-ID: <9vqce3$o93$1@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 @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 - 11:28:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US