How to COMMIT in POST-QUERY trigger

[LimonaM]

Hello.

How can i COMMIT in POST-QUERY trigger, any ideas?

L

 

[lewisp]

Why would you want to commit in a post-query trigger?

Anyway,

POST-QUERY:

DECLARE
tm TIMER := Find_Timer('T_COMMIT');
BEGIN
IF Id_Null(tm)
THEN
tm := Create_Timer('T_COMMIT',1,NO_REPEAT);
END IF;
END;


WHEN-TIMER-EXPIRED:

IF Get_Application_Property(TIMER_NAME) = 'T_COMMIT';
THEN
Commit_Form;
END IF;

 

[LimonaM]

I need commit, because my post_query trigger changes entry STATUS from 1 to 2. Then i need commit;

 

[LimonaM]

I need commit, because my post_query trigger changes entry STATUS from 1 to 2. Then i need commit.

 

[lewisp]

I suggest you put the commit (as above) in the POST-SELECT in that case.

 

[LimonaM]

I just write that code and it should work? or do i have to change something, because i wrote it and it doesn't happend anything.

 

[lewisp]

How are you changing the status?