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

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 02 Mar 2007 23:38:07 +0100
Message-ID: <45E8A74F.4090102@gmail.com>

Phil Lawrence schrieb:
> 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
>

Indeed, i overlooked it in your example, good to know, you got it working.

Best regards

Maxim Received on Fri Mar 02 2007 - 16:38:07 CST