Hi,
Question..
What syntax can I use if I want to loop in oracle forms? My problem is I want to insert mulitple records in a multirecord block. This is what I did and it seems like its not working. Please help!
[PHP]PROCEDURE P_EDIT_PO IS
CURSOR c_edit_podetail IS
SELECT rpi.rec_no,
rpi.pack_ind,
rpi.comp_ind,
rpi.item,
rpi.item_parent,
rpi.item_desc,
rpi.vpn,
rpi.dept,
rpi.class
FROM ros_poe_items rpi,
ros_poe_entry roe
WHERE rpi.order_no = :B_ros_poe_entry.order_no
AND roe.order_no = rpi.order_no;
Go_Block('B_ros_poe_items');
Clear_Block(No_Validate);
First_Record;
for REC in c_edit_podetail LOOP
fetch c_edit_podetail into :B_ros_poe_items.rec_no,
:B_ros_poe_items.pack_ind,
:B_ros_poe_items.comp_ind,
:B_ros_poe_items.item,
:B_ros_poe_items.item_parent,
:B_ros_poe_items.item_desc,
:B_Ros_poe_items.vpn,
:B_ros_poe_items.dept,
:B_ros_poe_items.class;
Next_Record;
EXIT WHEN c_edit_podetail%NOTFOUND;
end LOOP;[/PHP]
Can anyone help me? this is really an urgent question.
thanks