UTL_SMTP and attachments

[Jack Parker]

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

[Hans Forbrich]

Re: UTL_SMTP and attachments

bsc7080mqc@mylx hq.com wrote:

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