Re: SQLPLUS, scripting problem

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