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.

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