Slide
‹#› of 37
Process Data
for i in 2..v_row_tt.count
loop
for r in v_groupRow_tt.first..v_groupRow_tt.last
loop
for c in
v_col_tt.first..v_col_tt.last
loop
if
v_col_tt(c).id = v_mapRows_tt(r)
then
DBMS_SQL.BIND_VARIABLE(v_cur_tt(r),
':'||v_col_tt(c).viewcol_tx,
v_data_tt(c).text);
end if;
end loop;
v_nr:=dbms_sql.execute(v_cur_tt(r));
end loop;
end loop;