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: Unix shell commands in Trigger?

Re: Unix shell commands in Trigger?

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/07/31
Message-ID: <8m2cr8$su2$1@perki.connect.com.au>#1/1

You can use external procedure call.
in general you configure the database to execute a DDL which calls sendmail in unix.
Tom
<rajg_at_rocketmail.com> wrote in message news:8lvg8u$s8n$1_at_nnrp1.deja.com...
> Hello,
>
> Is it possible to run a unix command through a trigger? I need
> to set up a trigger whenever the "email" column of a table is changed.
> This trigger should execute a sequence of unix commands (writing to
> a log file, sending an email) in addition to sql commands.
> How do i call unix commands in the trigger?
>
> thanks
> raj
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jul 31 2000 - 00:00:00 CDT

Original text of this message

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