Re: Can triggers in ORACLE 7.0.16 interact with operating system?

>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.