Fire a Program using a trigger

From: Bruno Georges <georgeb_at_cmiu.bt.co.uk>
Date: 1997/02/18
Message-ID: <3309FFA4.3642@cmiu.bt.co.uk>#1/1

Hi,

Does anyone know how to write a trigger which fires a program.

I need it to run a http_add_user prog on my web server, each time a user is added to the Oracle DB, the trigger should start the program: add_http_user(username, password, fullname);

i.e:
create trigger fire_exec
after insert or update on EMP
begin

• get the values inserted into emp
• the code to fire the exec with the emp new values as parameter end

Many Thanks in advance.

Bruno.

---

Bruno Georges
BT Research Labs
mailto:georgeb_at_cmiu.bt.co.uk

---

Received on Tue Feb 18 1997 - 00:00:00 CST