I am debugging a package. I don't understand why the loop cannot pick up the next record, I have record something like below
inventory_id url
1234
http://test1.html
1234
http://test2.html
1234
http://test3.html
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
....
BEGIN
v_inventory_item_id := p_dev_prods.FIRST;
WHILE v_inventory_item_id IS NOT NULL
LOOP
DECLARE
l_url VARCHAR2 (3000);
...........
BEGIN
l_url :=........
......
v_inventory_item_id := p_dev_prods.NEXT (v_inventory_item_id);
END;
END LOOP;
......
I don't understand why the output url only show
http://test1.html