Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unix shell commands in Trigger?
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
![]() |
![]() |