Re: Starting external Programms

You use the "extproc" facility that is described in the Data Cartridge Developer's Guide, found in the regular doc set and available on the technet site and pretty much any server product cd-rom. A "c" program started this way is running like any C program under the OS. You can make OS calls directly and do not need OCI or Pro*C unless you are connecting back into Oracle with a new session. Moreover, the external program is part of the session space of the calling pl/sql (trigger, stored proc, etc) and cannot do ddl or commit transactions.

The doc has some good examples and there is probably some sample source on technet as well. Register if you have not at technet.oracle.com, it's free and useful.

Roger Snowden

Joerg Lanzinger wrote:
>
> 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) ? *=-
Received on Sat May 22 1999 - 09:48:35 CDT