I've a problem with the bulk and forall statement. I'm trying to do a update but for 564371 rows. I use 4 variable like this:
Type v_column1 IS TABLE OF myTable.column1%TYPE
. . .
So, I use this variable when I fetching the data for example (I use a cursor):
FETCH myCursor INTO v_column1, v_column2, v_column3;
And the problem is in the next instruction when I update a table.
FORALL j IN 1..v_column1.count
SET column1 = v_column1(j)
WHERE column2 = v_column2(j) AND column3 = v_column3(j);
All this works fine, but it's take a lot of time. For update 550 rows I had to wait 45 minutes and I need to update 564371 rows.
I hope your help. Please.