SQLPLUS, scripting problem

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 Received on Fri Jul 07 2000 - 00:00:00 CDT