Re: Can triggers in ORACLE 7.0.16 interact with operating system?
Date: 11 Sep 1994 17:48:07 GMT
Message-ID: <34vfsn$54p_at_dcsun4.us.oracle.com>
In article <CvIyB0.Cu7_at_lcpd2.SanDiegoCA.NCR.COM> "johnson premkumar" <johnsonpr_at_NCR.COM> writes:
>>Path: lcpd2!ncr-sd!ncrhub2!nntpa!gw1.att.com!csn!cherokee!uswest.com!kirani
>>From: kirani_at_advtech.uswest.com (Shekhar Kirani)
>>Newsgroups: comp.databases.oracle
>>Subject: Can triggers in ORACLE 7.0.16 interact with operating system?
>>Date: 31 Aug 1994 20:52:59 GMT
>>Organization: U S WEST Advanced Technologies
>>Lines: 19
>>Sender: kirani_at_uswest.com (Shekhar Kirani)
>>Distribution: world
>>Message-ID: <342qjb$kp_at_cherokee.advtech.uswest.com>
>>NNTP-Posting-Host: 130.13.21.9
>>Keywords: ORACLE, TRIGGER, MAIL
>>
>>Hi:
>>
>>I am working on a project where I need to send notify a user of the
database
>>when someone updates the database. So, I wanted to write a trigger for a
table
>>add/update and collect the information, send as an e-mail to the user. I
am
>>wondering is there a way to communicate with an external program or UNIX
from
>>trigger code? Please let me know. In a situation like this, if there is
>>any alternative, please let me know.
>>
>>Thanks,
>>Shekhar Kirani
>>
>>
>>
>>--
>>----------------------------------
>>4001, Discovery Drive, Suite 270
>>Boulder CO-80303. (303)-541-6420.
>>----------------------------------
>
>
> It is not possible to call C program directly from trigger, But
>you
> can invoke SYS.DBMS_PIPE package to send message from database trigger
> and access the message from PRO*C program.
>
> Thanks.
> Johnson.
>
>
>
One more way
There is a oracle product called Oracle Alert, using this you can define event alerts to notify the users through email, depends on database events you define in alert. Received on Sun Sep 11 1994 - 19:48:07 CEST