Re: SQLPLUS, scripting problem

"Jerra" <jerra_at_aland.net> wrote in message news:8k4ro5$rk2$1_at_gandalf.alcom.aland.fi...
> Hi,
>
> I'm trying to make something similar to a report.
>
> 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.
>
> Second thing how do I turn of the feedback showing what variables has been
> changed?
> old 22: '&startdate'
> new 22: '01-01-2000'
>
>
> Is this all in the Oracle docs?
>
> TIA!
>
> /Jerra
>
>

You must be doing something wrong. Without seeing the script it is very difficult to determine what you are doing wrong. The problem can occur when you don't terminate with a ; or a / on the next line, but instead have a few empty lines. Each individual line means 'run buffer'. It is customary to end a script with the exit command, please note however this will terminate sql*plus.
The answer to your second question is
set verify off

The answer to your third question is
YES, of course

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Jul 07 2000 - 00:00:00 CDT