Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using UTL_SMTP to email data from the database
Thanks for the reply, but I don't want to send it through an attachement. I am querying 1 line with 3 columns to be used as a "business scoreboard". Can you give me the syntax for concatenating a select statement into the mail body. I tried it and I can't get it to work.
Thanks,
jg
"Klaus Zeuch" <KZeuchnospam_at_hotmail.com> wrote in message
news:9cp6mm$g3r$1_at_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 Thu May 03 2001 - 11:04:04 CDT