Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding records int BLOCK depending on a loop

940100Sep 7 2012 — edited Sep 10 2012
Hi all,

I am experiencing problems doing the following:

When i push a button i call a cursor that returns several records, depending on some values on that record i should add or not a record to a block.

Somoeone could tell me how to do it, i am doing:

GO_BLOCK('BLOCK');
FOR reg in cursor
LOOP
..
..
if reg.value = 'S' then
create_record;
:BLOCK.VALUE = 'S';
end if;
..
..
END LOOP
close cursor;
Exception
when others
close cursor;


thx in advance!!!
This post has been answered by CraigB on Sep 10 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2012
Added on Sep 7 2012
4 comments
390 views