Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: pl/sql - os interaction
The simplest thing you can do is upgrade to 8i. Then use UTL_SMTP.
Daniel Morgan
sbrudner wrote:
> All,
>
> Does anyone know how to call a simple shell script from within PL/SQL.
> I am trying to create a trigger failure notification. I planned on
> using the inherent email ability of unix in a shell script combined
> with simple exception logic. I didn't know, that you can't call this
> script from within the PL/SQL code. I can't use Java, because of the
> Oracle version (8.0.5 means no jserver). Is there a simple way to do
> this? Help.
>
> Thanks.
Received on Mon Mar 11 2002 - 12:45:02 CST