Re: call system exe from a trigger

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 10 Jan 2000 20:43:59 +0800
Message-ID: <3879D40F.2F84@yahoo.com>

Scott Patterson wrote:
>
> Is there a way to execute a system command (in this case unix) from a
> trigger. In the past I have used dbms_pipe to a system daemon. One of my
> colleagues assures me there is a way to run system commands without the
> daemon but can not remember how it was done.
>
> In particular I would like to send mail.
>
> anyone?
>
> Scott

Read up on external procedures (available from 8.x) Essentially you tweak you SQL net instance so it 'listens' for a request to run an external program...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Jan 10 2000 - 06:43:59 CST