I *want* to spool query text...

I am invoking a sql script like so:

${ORACLE_HOME}/bin/sqlplus -S /NOLOG <<EOF 2>&1 1>/dev/null CONNECT ${ORA_USER}/${ORA_PASS}@${ORA_DB} SPOOL ${spoolfile}
@${sqlscript} ${args}
SPOOL OFF;
EOF This is fine, except the text of the statements in $sqlscript are not echoed in the spool file.

Is there any way to get the statements "list"ed in the spool file along with the output?

Thanks,
Phil R Lawrence Received on Fri Mar 02 2007 - 14:17:45 CST