PLSQL: sending email method?

From: David Van Zandt <dvanzandt_at_iquest.net>
Date: Mon, 13 May 2002 22:12:07 -0500
Message-ID: <ld%D8.601$L4.166880@news1.iquest.net>

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? Received on Mon May 13 2002 - 22:12:07 CDT