.sql file

From: sappi <swapnareddy_09_at_yahoo.com>
Date: 8 May 2006 20:08:14 -0700
Message-ID: <1147144094.898690.324280@y43g2000cwc.googlegroups.com>

Hi all,

I have created a .sql file which has insert statements, invoking procedures and other functions.

when i execute the script, It is running fine by outputting "procedure ran successfully".

But i want to see the output as

inserted 28569 rows successfully.

procedure ran successfully

I mean ,if we want to see all actions performed,how should I go about it.where shouldi include begin and end

eg: here is the .sql file

declare
RetVal NUMBER;

  P_QUERY VARCHAR2(200);
  P_DIR VARCHAR2(200);
  P_FILENAME VARCHAR2(200);
  P_INCLUDE_HEADER NUMBER;
  P_SEPARATOR VARCHAR2(200);
  P_FIELDS_ENCLOSED_BY VARCHAR2(200);

pu_unknown_excep EXCEPTION;
PRAGMA EXCEPTION_INIT (pu_unknown_excep, -20009);

BEGIN
SELECT TO_CHAR(SYSDATE,'YYYYMMDD') INTO TODAY FROM dual;

insert into BBT_TBL
 (select
 to_char(trunc(sysdate),'YYYYMM') RPT_YYYYMM ,

 EMPLOYERGROUPID           ,
 EMPLOYEESSN               ,
 RELATIONSHIPCODE          ,
 GENDER                    ,

 DATE_OF_BIRTH
   from BBT_IN_ELG_XTB XTB);

--commit;

 Rollback;

--calling procedure

declare
BOM INT;
TERM_BY_DEL INT;
ADJ_BY_ADD INT;
EOM INT;
HIRE_CUR_MTH INT;
TERM_CUR_MTH INT; begin

MTHLY_BILLING_REPORT(BOM,TERM_BY_DEL,ADJ_BY_ADD,EOM,HIRE_CUR_MTH,TERM_CUR_MTH); end;

  BEGIN

  P_QUERY := 'SELECT * FROM MTHLY_BILL_RPT_V';
  P_DIR := '/mar/tmp';
  P_FILENAME := 'bbt_Rpt';
  P_INCLUDE_HEADER := 1;
  P_SEPARATOR := ',';
  P_FIELDS_ENCLOSED_BY := NULL;

  RetVal := DUMP_CSV ( P_QUERY, P_DIR, P_FILENAME, P_INCLUDE_HEADER, P_SEPARATOR, P_FIELDS_ENCLOSED_BY );

• COMMIT; ROLLBACK; END; end; / exit;

Received on Mon May 08 2006 - 22:08:14 CDT