Re: Using UTL_SMTP to email data from the database

From: Klaus Zeuch <KZeuchnospam_at_hotmail.com>
Date: Wed, 2 May 2001 15:45:40 +0200
Message-ID: <9cp6mm$g3r$1@papyrus.erlm.siemens.de>

You can't send attachements with utl_smtp. If you simply want to send the results of your query, you have to concatenate them to the mail body (size restrictions!).
For sending mail with attachements you must use java stored procedures. For details see note 120994.1 on Oracle metalink.

Klaus

Jason Gonzales <jgonzales_at_plateautel.com> schrieb in im Newsbeitrag: teu7vr6lfnlcaa_at_corp.supernews.com...
> I have created a procedure to send email using the UTL_SMTP package. It
> works fine when sending simple text messages, but I would like to send
data
> queried from the database. Is there a way to send as part of the message
> body the results of a select statement?
>
> Any help would be appreciated.
>
>
>
Received on Wed May 02 2001 - 08:45:40 CDT