Message-ID: <F001.00454122.20020430121357@fatcity.com>
Date: Tue, 30 Apr 2002 12:13:57 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: dmeng@focal.com
Subject: PL/SQL Mail Question
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi All -
I am in the process of developing a PL/SQL procedure to monitor all
production databases and run into a road block:
The PL/SQL procedure is supposed to run my monitoring sql scripts and use
the UTL_SMTP package to send the output ( list of invalid objects, near
extent limits etc ) to the DBA. I tested sending a dummy message to me
using the UTL_SMTP and it works, now how do I send the output of a query as
part of the E-mail message?  Any pointers would be appreciated. Or can I
spool the sql output to a file and mail it as an attachment, but somehow I
think the first solution is cleaner.

TIA

Dennis Meng
Database Administrator
Focal Communications Corp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dmeng@focal.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).