HI,

THIS IS WORKING WORKING FOR ME...WHAT IS THE PROBLEM???IS THIS CORRECT???




***********************************

DECLARE

TYPE TY IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
OB TY;

BEGIN

SELECT ROWID BULK COLLECT INTO OB FROM ACCOUNT_STATEMENT;

FORALL I IN 1..2

UPDATE ACCOUNT_STATEMENT
SET end_stmt_bal=1,
begin_stmt_bal =1,
amt_purch =1,
amt_all_cash_adv =1,
total_credit_limit =1,
amt_payment =1,
finance_charges =1,
amt_late_fee =1,
amt_nsf_fee =1,
amt_mem_fee =1,
amt_collection_fee =1,
amt_recovery_fee =1,
amt_over_limit_fee =1
WHERE ROWID =OB(I);

END LOOP;


****************************************
I have given end LOOP for FORALL option..and without giving END;.............IS THIS OKEY??


Regards,

sam

[Edited by balajiyes on 10-11-2001 at 12:25 AM]