Re: Help with ACCEPT Syntax

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 13 Nov 2003 22:58:11 GMT
Message-ID: <70Usb.11051$sA1.4004@news01.roc.ny>

Try:
set verify off

For example:

SQL> select '&val' from dual;
Enter value for val: abc
old 1: select '&val' from dual
new 1: select 'abc' from dual

'ABC'

---

abc

SQL> set verify off
SQL> select '&val' from dual;
Enter value for val: xyz

'XYZ'

---

xyz

Anurag

"Sean Clark-McCarthy" <sclarkmccarthy_at_comcast.net> wrote in message news:8216df34.0311131407.77ed00f7_at_posting.google.com...
> Hello,
>
> I'm not sure if this is possible, but i'm creating a script that
> prompts a user to enter some data. This is basically a script builder
> which builds scripts based on what the user enters. The only problem
> i'm running into is the OLD and NEW lines are printing out in the
> spool file. When I run the spool file, the line right after the old
> new line does not get executed because of the ; missing on the old and
> new and then being on the next line..
>
> Hopefully i'm not confusing you.
>
> Is there a way to turn these off? some environment variable for
> something similar that I can eliminate these lines from printing in
> the spool file?
>
> Thanks for your help!
>
> Sean
Received on Thu Nov 13 2003 - 16:58:11 CST