hello friends good evening
wanted to make a query regarding the version oracle 9i:
it is possible that I can implement BULK COLLECT in this version, I have some insert that are very slow.
this code of examples I want to change it by BULK COLLECT
forall pind in 1..arr_phypidee.phy_ctrl_num.count
INSERT INTO phypidee
(phy_ctrl_num, org_lvl_child,
prd_lvl_child, inv_type_code,
phy_cnt_stat, phy_frz_date, phy_no_cnt,
on_hand_qty, on_hand_retl,
on_hand_cost, phy_frz_retl_prc, phy_frz_cst,
phy_act_cnt, phy_cst_var, phy_retl_var,
phy_per_var, phy_qty_var, phy_cst_per, phy_retl_per,
phy_per_abs, phy_retl_abs, phy_cst_abs, phy_qty_abs,
phy_cst_per_abs, phy_retl_per_abs, phy_frz_time)
VALUES
(
arr_phypidee.phy_ctrl_num(pind), arr_phypidee.org_lvl_child(pind),
arr_phypidee.prd_lvl_child(pind), arr_phypidee.inv_type_code(pind),
arr_phypidee.phy_cnt_stat(pind), arr_phypidee.phy_frz_date(pind), arr_phypidee.phy_no_cnt(pind),
arr_phypidee.on_hand_qty(pind), arr_phypidee.on_hand_retl(pind),
arr_phypidee.on_hand_cost(pind), arr_phypidee.phy_frz_retl_prc(pind), arr_phypidee.phy_frz_cst(pind),
arr_phypidee.phy_act_cnt(pind), arr_phypidee.phy_cst_var(pind),arr_phypidee.phy_retl_var(pind),
arr_phypidee.phy_per_var(pind), arr_phypidee.phy_qty_var(pind),arr_phypidee.phy_cst_per(pind),arr_phypidee.phy_retl_per(pind),
arr_phypidee.phy_per_abs(pind), arr_phypidee.phy_retl_abs(pind),arr_phypidee.phy_cst_abs(pind), arr_phypidee.phy_qty_abs(pind),
arr_phypidee.phy_cst_per_abs(pind), arr_phypidee.phy_retl_per_abs(pind), arr_phypidee.phy_frz_time(pind)
);
p_cont_phypidee := p_cont_phypidee + arr_phypidee.phy_ctrl_num.count;
inicializar_arr_pid;
END LOOP; -- Cursor C3