Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling external program from trigger??? Urgent !!!!
Santosh Lokhande schrieb:
>
> hi,
> Is it possible to call an existing external program from a database
> trigger ? If yes, how and what would be the pros and cons of such a
> system
> Any help is highly appreciated and thanks in advance
> regards,
> Santosh
Why not?
The "how to" depends on the version of oracle you use.
v7: use dbms_pipe and a listener demon who then starts the external programm
v8: define the external procedure and call it like any other PL/SQL proc.
HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE
Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm
Received on Thu Jan 21 1999 - 01:28:29 CST