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
Date: 1996/03/13
Message-ID: <4i54kv$9r4_at_amdint.amd.com>#1/1
Hello Everybody,
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?
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.