Re: pl/sql - os interaction

ninetyplus_at_aol.com (sbrudner) wrote in
news:36832922.0203111015.2ffd77fa_at_posting.google.com:

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

It's been a while and I don't have the information handy but hopefully someone else will fill in the missing information. There is a package called DBMS_PIPE which can be used to send messages to external programs. There is also a sample C program which can be used to pull messages from the pipe. When it comes time to send the email notification the PL/SQL code uses DBMS_PIPE.SEND_MESSAGE to send a message. The C program on the other end of the pipe receives the message and sends the email. I used this in a system I designed some years ago but don't remember the details now. Anyone know where to find the sample C program that sits on the other end of the pipe?

-- 
Ken Denny
http://www.kendenny.com/

A duck walks into a drugstore and says, "Gimme some Chapstick. You can put 
it on my bill."