Re: UNIX Mail From a Trigger?

From: Mike Rushton <mike_at_mrush.demon.co.uk>
Date: 1996/03/17
Message-ID: <314b42a0.10015354_at_news.demon.co.uk>#1/1


Jim.Smith_at_AMD.COM (Jim Smith) wrote:

>Hello Everybody,
>To help me monitor Oracle errors as they happen, I was thinking about
>having an ON-INSERT database trigger fire a UNIX mail message to
>my UNIX mail account whenever there is a journal entry into my error table.
>
>Has anyone seen this done in a database trigger, or a stored procedure?
>
>I've been able to get the host script to work within SQL*Plus, but I haven't
>been able to get it to work from a stored procedure or database trigger.
>Any thoughts or suggestions?
>Jim

I could be wrong, but i don't think you can do this. PL/SQL does not support the HOST command so you cannot issue a host from either a database procedure, function or trigger.  



Mike Rushton
mike_at_mrush.demon.co.uk
Received on Sun Mar 17 1996 - 00:00:00 CET

Original text of this message