parse sql in package with cursor
Assume that I creates a package and it contains store procedure call cal_val(). Inside call_val(), I declare cursor cur_data and it contains about 2000 records. After that, I open this cursor and loop by records, calculate (about 5 operates) for per record so I can not use FORALL. Example one of these operates:
update table_a set val = cur_data(i).value;
And with 2000 records, oracle will hard parse 2000 times with above sql ? And remember that it inside package !
I use 9.2.0.4
Thanks