UTL_SMTP and attachments

#1

Early this year I wrote an article on utl_smtp and working through all of
the issues surrounding it. I've offered it to Oracle - who have not fallen
over themselves to take it. I've also got version 8 and version 9 packages
built to support the article. Total size of the article (MSWord) and
attachments are ca. 150K, so I won't post them here. However, if you have
interest in the topic let me know and I'll be happy to email you a copy. I
don't hang out here so write me directly vze2qjg5 verizon net (you have to
put the address together first).

Regards,
Jack Parker

#2

bsc7080mqc (AT) mylxhq (DOT) com wrote:

Quote:

Glad to see someone else has spent some equal time on building a email
tool. I launched mine off of another developers work but made a number of
modifications to mine :

- PLSQL solution
- Converted to UTL_TCP
- Support for HTML Formatted messages
- Support for binary attachments as well as flat file text attachments
- Server verification to validate a mail server is up and running
- Server timemout logic
- etc

Additionally, took what I learned from there and leveraged it against a
FTP routine that handles MVS Mainframe file transfers, binary and ascii
transfers for non-mainframe machines. Supports GET/PUT/ RENAME/DELETE
functionality.

Have you done any work with binary attachments with your solution or work
on FTP solutions

Barry Chase
- MylxHQ - Oracle Resource Portal [http://www.mylxhq.com]

Have you looked at Oracle's Workflow functionality? That shows a number of
tricks, especially related to the HTML transmission.

/Hans

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

UTL_SMTP and attachments

comp.databases.oracle comp.databases.oracle

UTL_SMTP and attachments - 07-11-2004 , 07:56 AM

Re: UTL_SMTP and attachments - 07-11-2004 , 05:07 PM