Re: easy sql question
From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 23 Jan 2003 12:50:35 +0000
Message-ID: <b0ohe0$joa$1_at_ctb-nnrp2.saix.net>
Date: Thu, 23 Jan 2003 12:50:35 +0000
Message-ID: <b0ohe0$joa$1_at_ctb-nnrp2.saix.net>
IKerr. wrote:
<snipped>
> "SP2-0734: unknown command beginning "Enter valu..." - rest of line
> ignored."
>
> How can I make the lines disappear from the spooled script before it is
> run.
[Quoted] SET define off
[Quoted] This will disable all SQL*Plus prompts caused by the & char, e.g.
SQL> Prompt &Hello there
Enter value for &Hello:
vs.
SQL> set define off;
SQL> Prompt &Hello there
&Hello there
-- BillyReceived on Thu Jan 23 2003 - 13:50:35 CET