Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Refreshing Data In POST-DATABASE-COMMIT

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US