Re: SQL script with parameters

From: news.plusline.de <r_at_r.rr>
Date: Thu, 6 Dec 2001 10:26:03 +0100
Message-ID: <9undk2$g1j$1@news.f.de.plusline.net>

Hey,

use the following command before spool report.txt:

set verify off

HTH Robert

"Matthieu DEGLIN" <mdeglin_at_remove-me.partner.auchan.com> wrote in message news:9un8al$kq4$1_at_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 - 03:26:03 CST