ORA-12838: cannot read/modify an object after modifying it in parallel

[rohanem]

Hi,
I am trying to execute a PL/SQL where I have a cursor and selecting columns from a table in one database.In the loop,I am updating the same columns in a table in another database(I am using the parallel hint in the update clause).But it shows me this error

ORA-12838: cannot read/modify an object after modifying it in parallel.

Do u suppose I have to give a commit?I mean is the table getting locked or something?..Please help..URGENT!!

 

[rohanem]

for further help,this is how the Pl/SQL is

declare cursor c1 is
select col1,col2 from table1@db1
where date_col between date1 and date2;
begin
for c in c1
loop
update table2
set col1=c.col1,
col2=c.col2
where date_col between date1 and date2;
end loop;
end;
/