I am debugging a package. I don't understand why the loop cannot pick up the next record, I have record something like below
I want to know if lopping for next record will not pick up the next record of the inventory_id is the same?
I have the oracle program something like below
v_inventory_item_id := p_dev_prods.FIRST;
WHILE v_inventory_item_id IS NOT NULL
l_url VARCHAR2 (3000);
v_inventory_item_id := p_dev_prods.NEXT (v_inventory_item_id);
I don't understand why the output url only show http://test1.html