Re: Starting external Programms

Hello!

> I´m running Oracle 8.0.5 on linux and I want to execute an external
> Programm from a trigger (For expample if a DB-table is updated, a
> Perl-Programm should send a Mail or do some other work). Is there any
> command in Oracle to do this.

You can do this by using an external procedure that uses the 'system' call via OCI. Of course this introduces some security problems as the program will run with the dbadmin's uid.

But it works fine with me.

CU
  J.Lanzinger

--

___  __
\_ \ \ \     Joerg Lanzinger, Tankenrainer Str. 33, 82362 Weilheim 
 _\ \ \ \__    EMail: joerg.lanzinger_at_in.tum.de
 \___\ \___\     WWW: http://www.in.tum.de/~lanzinge


         -=*  REALITY.SYS maybe corrupt - Reboot universe (Y/N) ?  *=-