Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to attach BLOB to email using pure PLSQL solution
<bsc7080mqc_at_mylxhqdotcom.com> wrote in message
news:ud78609nrmjapkqccg37pjq8ocq5lpsa5i_at_4ax.com...
> I have tried a myriad of things with no luck.... small files fine..
> anything over 32k..nothing. I have been using the
> UTL_ENCODE.ENCODE_BASE64 command but little or no luck. Any ideas ?
>
>
Hi,
You might have to consider other means instead of pure PL/SQL.
I found the following entry on AskTom: "Sending e-mail! -- Oracle 8i
specific response" at
http://asktom.oracle.com/pls/ask/f?p=4950:8:2301380428634330506::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:255615160805,
in which Thomas Kyte uses the code from "Loading and using the JavaMail API"
section on pp.1236 to 1243 of his book, "Expert One-on-One Oracle"
(A-Press:2003).
Thomas Kyte creates a procedure that passes a BLOB as an attachment.
Douglas Hawthorne Received on Sat Mar 27 2004 - 04:44:55 CST