how to loop in oracle forms

[krizzie khonnie]

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_entr y.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_item s.rec_no,
:B_ros_poe_item s.pack_ind,
:B_ros_poe_item s.comp_ind,
:B_ros_poe_item s.item,
:B_ros_poe_item s.item_parent,
:B_ros_poe_item s.item_desc,
:B_Ros_poe_item s.vpn,
:B_ros_poe_item s.dept,
:B_ros_poe_item s.class;
Next_Record;
EXIT WHEN c_edit_podetail %NOTFOUND;
end LOOP;[/PHP]

Can anyone help me? this is really an urgent question.

thanks

[amitpatel66]

You are trying to call another block after your select query. Could you please let us know what you are trying to do exactly?