From: "Jacques Desmazieres" <jacques.desmazieres@is2france.com>
Subject: Re: SQLPLUS, scripting problem
Date: 2000/07/07
Message-ID: <7Ro95.629$VU5.2006153@nnrp2.proxad.net>#1/1
References: <8k4ro5$rk2$1@gandalf.alcom.aland.fi>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@proxad.net
X-Trace: nnrp2.proxad.net 962992579 213.228.11.101 (Fri, 07 Jul 2000 19:56:19 CEST)
Organization: Guest of ProXad - France
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 07 Jul 2000 19:56:19 CEST
Newsgroups: comp.databases.oracle.misc


> First of all, how do I make SQLPLUS to run the script only once, it runs
> forever and ever prompting for new values after each run? CTRL+C only
works.

sqlplus user/password@sid @script_name

This works fine if you do not have a recursive call of your script

If you do not want Oracle to ask you for the parameter value each time it
appears in the script, you can proceed like this:

DEFINE myValue = &1

replace &1 by &myValue everywhere in the script (should work, but I did not
get time to test it)

> Second thing how do I turn of the feedback showing what variables has been
> changed?
> old    22:    '&startdate'
> new    22:    '01-01-2000'

Set verify off

It is in the SQL*Plus doc

Jacques