Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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:
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
![]() |
![]() |