Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL script with parameters
Try this,
after the
sqlplus -s usr/pwd << EOF
set verify off
@build_report.sql '01' '11-jun-2001'
spool off
quit;
EOF
Hope this helps
Matthieu DEGLIN wrote:
>
> 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
-- Regards, Praveen MohananReceived on Thu Dec 06 2001 - 13:39:51 CST