oracle trigger - return control after procedure starts
Hi all,
I've got table table1 with trigger trigger1
It works fine, I mean it starts procedure procedure1 after performing update on table table1.
This is part of main procedure procedure_main. It inserts data into tables t1@dblink, t2@dblink, ... tN@dblink.
After all inserts are complete I perform update table1@dblink.
Procedure procedure1 mentioned earlier runs aggregation of data @ remote server. This is important, because I can't waste time and machine resources at local server to aggregate data at remote server.
I've got table table1 with trigger trigger1
CREATE or REPLACE TRIGGER trigger1
AFTER UPDATE
ON table1
BEGIN
procedure1;
EXCEPTION
WHEN OTHERS THEN
[write error log]
END;
It works fine, I mean it starts procedure procedure1 after performing update on table table1.
This is part of main procedure procedure_main. It inserts data into tables t1@dblink, t2@dblink, ... tN@dblink.
After all inserts are complete I perform update table1@dblink.
Procedure procedure1 mentioned earlier runs aggregation of data @ remote server. This is important, because I can't waste time and machine resources at local server to aggregate data at remote server.
0