Re: PLSQL: sending email method?

In article <cK0E8.608$L4.168541_at_news1.iquest.net>, "David says...
>
>Mea culpa, I should have added that this has to work in a 7.3.4 world (HPUX
>host) just a few more months....
>
>I have read somewhere that a procedure can execute OS commands, but there
>seem to be very few examples. For instance, using the job queue to schedule
>exports instead of cron. I may break down and open a TAR....
>
>Tks for the referral.

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:772225930495

for some ideas

>
>
>----- Original Message -----
>From: "Bricklen Anderson" <bricklen_at_shaw.ca>
>Newsgroups: comp.databases.oracle.misc
>Sent: Monday, May 13, 2002 10:44 PM
>Subject: Re: PLSQL: sending email method?
>
>
>> Easily done. Try http://asktom.oracle.com and do a search for 8i
>> (assuming that you are using 8.1.x) and email. There are lots of
>> references there.
>>
>
>"Bricklen Anderson" <bricklen_at_shaw.ca> wrote in message
>news:3CE0871A.2AA06539_at_shaw.ca...
>> Easily done. Try http://asktom.oracle.com and do a search for 8i
>> (assuming that you are using 8.1.x) and email. There are lots of
>> references there.
>>
>> hth
>>
>> Bricklen
>>
>> David Van Zandt wrote:
>> >
>> > Here's one not in the books: I'm trying to write PL/SQL to periodically
>> > query a user table for its row count, which is normally zero; if the
>result
>> > is greater than a certain integer, then send an email to an operator to
>take
>> > corrective action. Basic function and procedure stuff -- except for
>that
>> > last part; I'm clueless. I'm used to writing a Korn shell to launch
>> > SQLPlus, then calling mailx to alert the operator.
>> >
>> > Oh, and I'm trying to have this run using DBMS_JOB.
>> >
>> > Can anyone help the poor boy, please?
>>
>> --
>>
>>
>> -----------------------------
>> * http://pipers.hypermart.net *
>> -----------------------------
>
>

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp