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]
