Re: Using Triggers w/ ORACLE7

pt_at_wzl-wm1.wzl.rwth-aachen.de wrote:
: 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 ----------+
: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Look at page A-15 to A-25 of Oracle7 Server Application Developer's Guide. It explains how to use triggers, alerts, and pipes to have Oracle send events and data to a C program. I tried to do this but had no luck. If anyone has a small working example I would love to see it. I think I had a problem with database permissions.

Good Luck

Nathan Received on Tue Apr 04 1995 - 00:00:00 CEST