SQL script with parameters

From: Matthieu DEGLIN <mdeglin_at_remove-me.partner.auchan.com>
Date: Thu, 6 Dec 2001 09:03:48 +0100
Message-ID: <9un8al$kq4$1@reader1.imaginet.fr>

Hello,

I need to build a report using a SQL script. I wrote a shell like that:

sqlplus -s usr/pwd << EOF
spool report.txt
@build_report.sql '01' '11-jun-2001'
spool off
quit;
EOF The problem is : I found those lines in my report.txt

old  21: WHERE B_BON_PRE.CO_PF='&&1'
new  21: WHERE B_BON_PRE.CO_PF='01'
old  22: AND    B_BON_PRE.DA_LIV =TO_DATE('&&2')
new  22: AND    B_BON_PRE.DA_LIV =TO_DATE('11-jun-2001')

How can I make tose lines to dissappear ?

Thanx for help.
Matthieu Received on Thu Dec 06 2001 - 02:03:48 CST