Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to attach BLOB to email using pure PLSQL solution

Re: How to attach BLOB to email using pure PLSQL solution

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Sat, 27 Mar 2004 10:44:55 GMT
Message-ID: <HWc9c.126981$Wa.26421@news-server.bigpond.net.au>


<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US