table type indexed by binary integer [message #629938] |
Wed, 17 December 2014 23:39 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi all,
Can you please explain this? in 1,2 code
Declare
-- which is a table of type Number indexed by binary integers.
x_pck_detail_tab wsh_util_core.id_tab_type;
Begin
for c_rec in c1 loop
.......
for c_detail_rec in c2 loop
i := i + 1;
x_pck_detail_tab(i) := c_detail_rec.delivery_detail_id; ----->(1)
END LOOP;
package.procedure(x_pck_detail_tab);
x_pck_detail_tab.delete; --->(2)
commit;
END LOOP; --Main Loop
Thanks
|
|
|
|
|
|
|