From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Subject: Re: SQLPLUS, scripting problem
Date: 2000/07/07
Message-ID: <962995199.18980.2.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> <8k55pm$39u$1@gandalf.alcom.aland.fi>
X-Trace: news.demon.nl 962995199 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


Yep, caught!!!!!
set is a sql*plus command (except for to make it confusing set transaction
and set autotrace) and doesn't to be followed either by a ; or  a /.
The / means "run buffer"
So at the end of the script you are just repeating the last command three
times.

Hth,

Sybrand Bakkker, Oracle DBA


"Jerra" <jerra@aland.net> wrote in message
news:8k55pm$39u$1@gandalf.alcom.aland.fi...
> I am using a cursor and the ACCEPT command.
>
>
> SET ECHO OFF;
> SET HEADING OFF;
> SET SERVEROUTPUT ON
> SET LINESIZE 800
> SET PAGESIZE 1000
> CLEAR COLUMNS;
> CLEAR BREAKS;
> CLEAR SCREEN;
> CLEAR SQL;
> PROMPT
> ACCEPT showlist char PROMPT 'showlist? (y/n)  '
> PROMPT
> ACCEPT oid char PROMPT 'BANK ID?     '
> PROMPT
> ACCEPT tran_date date format 'DD-MM-YYYY' PROMPT (DD-MM-YYYY) =>   '
> DECLARE
>
>
>  /*cursor variabler*/
>
>  CURSOR cur_unv_onl IS  SELECT ...............
>
>
> BEGIN
>  dbms_output.enable(1000000);
>
>
>
>
>
 dbms_output.put_line('______________________________________________________
> ________________________________________');
>
> xxxxxxxxxxxxxxxxxx
>
>  dbms_output.put_line(tran_sum||' buckalores');
>
>
 dbms_output.put_line('______________________________________________________
> ________________________________________');
>
>
> END;
> /
> PROMPT Done with the script....
> UNDEF startdate
> UNDEF oid
> UNDEF showlist
> /
> SET SERVEROUTPUT OFF
> /
> SET ECHO ON;
> /
> SET HEADING ON;
> /
>
>
>