Error: PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL

[gandolf989]

update sourcing set DISC = trunc(to_date('01/01/1901','MM/DD/YYYY')); is the only statement you need as you are changing every row in the table in every iteration of the loop.

and stop fetching across a commit - you will end up with ORA-0155

I disagree with both of your answers... There are restrictions on using a FORALL clause. The original poster should change his code to a regular for loop.

FOR i IN 1..l_data.COUNT
LOOP
...
END LOOP;
COMMIT;

You don't need to commit that much, you might be able to only commit at the end.