GO_BLOCK in WHEN_VALIDATE Trigger

最新推荐文章于 2023-05-31 22:20:47 发布

转载最新推荐文章于 2023-05-31 22:20:47 发布 · 550 阅读

本文探讨了在Oracle Forms中如何在when_validate_item触发器中使用含有GO_BLOCK指令的过程。通过巧妙利用WHEN-TIMER-EXPIRED触发器，可以在字段修改前执行带有GO_BLOCK指令的过程，同时确保验证流程正常进行。

1 down vote favorite

I'm working with oracle forms. I've a procedure I have to run whenever a specific field's value is modified. The procedure I have to execute contains a go_block instruction, which can't be used in the when_validate_item trigger. Is there anyway to bypass this?

EDIT

I have to use the when_validate_item, because the procedure I have to run has to be run when the field is modified, BUT BEFORE the validation is executed.

asked Sep 26 '12 at 18:42

Nacho321

723 5 15 37

add a comment |

3 Answers 3

active oldest votes

up vote 6 down vote accepted

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