Re: Fire a Program using a trigger

From: Simon Taylor <simon_at_microlistics.com.au>
Date: 1997/02/20
Message-ID: <5egdom$9qb@sleipnir.iaccess.com.au>#1/1

In article <3309FFA4.3642_at_cmiu.bt.co.uk>, georgeb_at_cmiu.bt.co.uk wrote:
>Hi,
>
>Does anyone know how to write a trigger which fires a program.

Ask your Oracle support people about the dbms_pipe package. properly configured, this allows you to write a server program that will execute operating system command lines in a manner synonymous with the Unix system() call. Oracle will supply you with an example plsql package that I think is called "daemon.plsql".

If your Oracle is installed on Unix, look for,

$ORACLE_HOME/rdbms/admin/dbmspipe.sql

as a starting point.

I can supply you with some source code examples if you can't get any through Oracle.

Simon Taylor. Received on Thu Feb 20 1997 - 00:00:00 CST