From: "Sybrand Bakker" Subject: Re: SQLPLUS, scripting problem Date: 2000/07/07 Message-ID: <962995198.18980.0.pluto.d4ee154e@news.demon.nl>#1/1 X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 References: <8k4ro5$rk2$1@gandalf.alcom.aland.fi> X-Trace: news.demon.nl 962995198 pluto:18980 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Newsgroups: comp.databases.oracle.misc X-Complaints-To: abuse@nl.demon.net "Jerra" wrote in message news:8k4ro5$rk2$1@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