Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Calling external program from trigger??? Urgent !!!!

Re: Calling external program from trigger??? Urgent !!!!

From: Matthias Gresz <GreMa_at_t-online.de>
Date: Thu, 21 Jan 1999 08:28:29 +0100
Message-ID: <36A6D71D.75BF38B5@Privat.Post.DE>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US