Oracle Forms

Hi
Is it possible to manually execute a push button? The reason why I don't just call the procedure directly is because it has a go_block and when I put this on post_query at form level, it is giving me the error Illegal restricted procedure CLEAR_BLOCK in POST_QUERRY trigger.
I need a control block to populate when new form instance, I have the control block populating when Key_down trigger, Key_up trigger, Key_prvrec and key_nxtrec are encountered on the specific control block.

code snippit on above triggers is as follows

if :system.current_block = 'four' then
go_block('four_two');
populate_avail_activity;
go_block('four_control');
NEXT_RECORD;
else
NEXT_RECORD;
end if;

code snippit for procedure populate_avail_activity

declare
cursor xxxxx <--not important to know;
cursor2 xxxx <-- not important to know;
BEGIN

clear_block(no_validate);
FOR activity_rec IN activity_cur LOOP
:four_two.activity := activity_rec.activity;
next_record;
END LOOP;
FIRST_RECORD;

exception when others then
for new_activity_rec in new_activity_cur loop
:four_two.activity := new_activity_rec.activity;
end loop;
END;


as a work around I did have a pushbutton which just calls populate_avail_activity when pressed it works..now to just manually press it for them would be ideal.

Any suggestions please

Forms [32 Bit] Version 10.1.2.3.0 (Production)

Edited by: DM on Sep 3, 2009 11:36 AM