Re: I *want* to spool query text...

On Mar 2, 2:23 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> Phil Lawrence schrieb:
>
> > This is fine, except the text of the statements in $sqlscript are not
> > echoed in the spool file.
>
> set echo on

Thanks... the -S in
  ${ORACLE_HOME}/bin/sqlplus -S /NOLOG <<EOF 2>&1 1>/dev/null was overriding my attempts to use echo.

Without -S your suggestion works.

Phil Received on Fri Mar 02 2007 - 14:52:29 CST