Usually there is a restriction on using GO_BLOCK
or GO_ITEM
on a WHEN-VALIDATE-ITEM
. However there are a couple of ways to overcome this. One way is to use a WHEN-TIMER-EXPIRED
trigger. Here is how-
WHEN-TIMER-EXPIRED
Begin
if GET_APPLICATION_PROPERTY(TIMER_NAME) = 'NEW_TIMER' then
CALL_PROG_UNIT(); --This is your Procedure that calls the GO_BLOCK
/*Do rest of validation here*/
end if;
END;
WHEN-VALIDATE-ITEM
DECLARE
timer_id TIMER;
Begin
timer_id := CREATE_TIMER('NEW_TIMER',1,NO_REPEAT); --set a short timer so that the WHEN-TIMER-EXPIRED trigger is fired immediately
End;
What happens is - This will create & expire the timer as soon as the CREATE_TIMER
function is called and then the form level trigger WHEN-TIMER-EXPIRED
will check the expired timer name and call your program unit that has the GO_BLOCK
. Hope this helps.
http://stackoverflow.com/questions/12608330/go-block-in-when-validate-trigger