Using Triggers w/ ORACLE7

Hi,

we want to build an information-managment for our database in order to get centralized information about changes in the database. At the moment we want to use triggers on interesting tables to get these informations. The triggers write the changed data from all watched tables into one information table. Because there seems to be no way executing C-code instead of PL/SQL while processing triggers, the information-process needs to poll these information-table. Because I think it's not a good idea polling a table after a default timeslice, I hope there are still some different possibilities to synchronize the information flow. So if somebody has some ideas, or realized something equal to these problem it would be nice if he contacts me.

Thanks,

         Axel

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


+ W   W           + Axel Peters -------------------------------------+

+ W W W           + Machine Tool Laboratory university of Aachen ----+

+ WW WW ZZZZ      + Germany (WZL) -----------------------------------+

+ W   W   Z       + Steinbachstr. 53 b ------------------------------+

+        Z   L    + 52056 Aachen ------------------------------------+

+       ZZZZ L    + Phone:   (49) 241 807453 ---Sec: -7408 ----------+

+            L    + Fax:     (49) 241 873442 ------------------------+


+            LLLL + e-mail:  pt_at_wzl-wm1.wzl.rwth-aachen.de ----------+


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++