Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL script with parameters
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