Slide
‹#› of 37
Build Inserts
uDeclare
u type integer_tt is
table of integer;
v_cur_tt integer_tt;
Begin
for r in v_groupRow_tt.first..v_groupRow_tt.last loop
v_cur_tt(r):=DBMS_SQL.OPEN_CURSOR;
u for c in
c_cols(v_mapRows_tt(r)) loop
for i in
v_header_tt.first..v_header_tt.last loop
if
v_header_tt(i).text=c.name_tx then
v_col_tt(i):=c;
v_col_tx:=v_col_tx||','||v_col_tt(i).viewcol_tx;
v_val_tx:=v_val_tx||',:'||v_col_tt(i).viewcol_tx;
end if;
end loop;
end loop;
v_sql_tx:='insert
into '||v_map_rec.view_tx||
'('||v_col_tx||')
values('||v_value_tx||')';
DBMS_SQL.PARSE(v_cur_tt(r),v_sql_tx,DBMS_SQL.NATIVE);
uend loop;