Re: SQLPLUS, scripting problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/07
Message-ID: <962995199.18980.2.pluto.d4ee154e@news.demon.nl>#1/1

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_at_aland.net> wrote in message news:8k55pm$39u$1_at_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;
> /
>
>
>
Received on Fri Jul 07 2000 - 00:00:00 CDT