Re: Refreshing Data In POST-DATABASE-COMMIT

From: <elie.constantine_at_gmail.com>
Date: 4 Feb 2005 02:09:35 -0800
Message-ID: <1107511775.460188.122470@f14g2000cwb.googlegroups.com>

I used a timer! it's not a bad idea after all:

---

POST-DATABASE-COMMIT

---

DECLARE

	refresh_timer TIMER;
	time_needed NUMBER(7) := 500;

BEGIN
.
.
.

                                        XXP_UTILITIES.PO_Delete_Zero_quantities(:XXP_PURCHASE_HEADER.HEADER_ID);
.
.
.

	IF :PARAMETER.CANCREATETIMER = 1 THEN
		refresh_timer := CREATE_TIMER('refresh_timer', time_needed,
NO_REPEAT);
		:PARAMETER.CANCREATETIMER := 0;
	END IF;

END;

---

WHEN-TIMER-EXPIRED GO_BLOCK('XXP_PURCHASE_LINES');
EXECUTE_QUERY();
:PARAMETER.CANCREATETIMER := 1
; Received on Fri Feb 04 2005 - 04:09:35 CST