SQL & PL/SQL

Hi all,

First off all, I am not very good in PL/SQL so please bear with me:

I have a trigger on a table on after update event. Sample code of the trigger:

create or replace trigger t1
on table1
after update of col1
for each row
begin
for inx in varray1.first .. varray1.last
loop
do something;
end loop;
end;
/

This trigger throws an error saying "ORA-6502: value or numeric error" if I am trying to update anything into that table but the same trigger works fine when I remove "FOR EACH ROW" statement from the trigger. There is absolutely no change except removal of FOR EACH ROW clause.

I am unable to figure out why. Do anybody?

Thanks in adnvace.