Re: After-Insert-Trigger must call external application

Hi Dieter,

One of the way to execute external program code after database trigger fired is to use dbms_alert package. I like this way because database well separated from external application. And external application may be of any type on any languge.

To do this you should:

1. Add to database trigger procedure dbms_alert.signal
2. external application execute dbms_alert.register
3. external procedure call dbms_alers.wait in infinitive loop and wait for signal from database.

Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com

Dieter Ratsch <dieter.n-o-s-p-a-m.ratsch_at_epost.de> wrote in message news:<app6pj$4fg$00$1_at_news.t-online.com>...
> Hi there,
> is it possible, to start an external application on the DB-Server after
> inserting a row???
> Example:
> I insert a row in a table. After inserting the row I would like to start
> PHP.EXE or on our NT-Web-/DB-Server.
>
> I've read and tried out several hours to build triggers and
> PL/SQL-Procedures but I'm not able to get access to the OS to start
> external programs. The HOST-command is only available in SQL*PLUS - not
> in PL/SQL - or am i wrong?
> Any hints for a bloody beginner????
>
> best regards
> Dieter (mailto:kdr_at_epost.de)
Received on Wed Nov 06 2002 - 04:31:59 CST