Andi Voss wrote:

>Hi,
>
>is there a possibility to start a external program in/from a TRIGGER
>after a TRIGGER is executed (or STORED PROCEDURE or something else)? I
>would like to start a program (PHP-CLI (Windows) Script or a
>Shell-Script (Linux)) which starts an update routine to another database
>for the dataset which has changed.
>
>Thanks for help.
>Greets Andi
>
>

Andi,

you can write an UDF that accepts a string as parameter and un a program
defined by this string or use the string as parameters for a fixed
program. But I think you shouldn't do it ! UDF should be a simple
function, that runs fast. A bad written UDF could crash the server too.

Better write an app that pools the DB for some changes or even better an
app that receive events and react acording to it.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.3.2 - Release Date: 31/05/2005