UNIX Mail From a Trigger?

From: Jim Smith <Jim.Smith_at_AMD.COM>
Date: 1996/03/13
Message-ID: <4i54kv$9r4_at_amdint.amd.com>#1/1

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 Received on Wed Mar 13 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Gerard H. Pille: "Re: UNIX Mail From a Trigger?"
Previous message: badri: "Need procedure to change password"
Next in thread: Gerard H. Pille: "Re: UNIX Mail From a Trigger?"
Reply: Gerard H. Pille: "Re: UNIX Mail From a Trigger?"
Reply: Mike Rushton: "Re: UNIX Mail From a Trigger?"
Maybe reply: Yoram zilberberg: "Re: UNIX Mail From a Trigger?"
Reply: Rebecca R. Aponte: "Re: UNIX Mail From a Trigger?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message