Re: pl/sql - os interaction

From: Ken Denny <ken_at_kendenny.com>
Date: Mon, 11 Mar 2002 18:29:58 GMT
Message-ID: <Xns91CE8ABF068C7kendenny@65.82.44.7>

Ken Denny <ken_at_kendenny.com> wrote in
news:Xns91CE881E02D4kendenny_at_65.82.44.7:

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

There's more information here: http://www.oreview.com/9704flet.htm

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

"That's not a lie, it's a terminological inexactitude." -- Alexander Haig

Received on Mon Mar 11 2002 - 12:29:58 CST