This content has been marked as final. Show 4 replies
+"...but it was all illegal..."+
What do you mean exactly ?
Your only chance is to fire a timer in the POST-trigger, and in the WHEN-TIMER-EXPIRED-trigger issue the GO_ITEM.
Illegal. You can't write those codes in the post triggers.
This is one of the error thrown.
"Illegal restricted procedure GO_ITEM in POST_QUERY trigger."
DECLARE timer_id TIMER; one_second NUMBER := 1000; BEGIN <validations . . .> timer_id := CREATE_TIMER('timer', one_second,NO_REPEAT); END;
Bright idea! Million thanks!
Note: I have an typo error in my code. It should be
IF :item3 IS NULL AND :item1 IS NOT NULL THEN