OraFAQ Forum: Forms » why this code is not working ?

Home » Developer & Programmer » Forms » why this code is not working ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

why this code is not working ? [message #253057]

Sun, 22 July 2007 01:08

hussienburhan
Messages: 28
Registered: July 2007

Junior Member

hi
im tring to ftech mutliple reords to tabuler form text item
i write this code but its only fetch values for first record in the text item and do not fetch to other records in the same text item

Declare
cursor c is
select distinct group_a from sc_mast; <here i select all values
in my database that they are 63 values>

begin
for r in c loop
next_record;
:visib_groups.group_a:=r.group_a;<it assign vakues only for first record>
end loop;

end;

Report message to a moderator