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

[bsc7080mqc]

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]


On Sun, 11 Jul 2004 12:56:16 GMT, "Jack Parker" <vz******@verizon.net> wrote:

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]

bs********@mylxhq.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

[bsc7080mqc]

Actually I haven't looked at Workflow that much at all. I have seen several models of mail tools ... from PLSQL, Pro*C, Java, and
now as you suggest.. Workflow. I am particularly happy with the PLSQL solution we use now. It is in a native language that I am very
comfortable with and fits our environment where I work. I have spent the last 2 years tweaking it here and there, and the same with
the FTP solution. If I was to change anything, I would probably go with a java solution so that it would be cross platform and not
restricted to specially Oracle only, however.... I doubt I could get my employer to buy into it as easily. It was hard enough to
convince them to let me turn on the mail utility and ftp utility as it stands now... but in the end I did finally persuade them to
do so. LOL.

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

P.S. You are welcome, or anyone for that matter, to take a look at what I did. Just head to my site (see above). I like to hear when
someone else is going down the same path as I did....and others for that matter. Always interesting to see what they did with their
solution. Might learn some new tricks in the process.

On Sun, 11 Jul 2004 22:07:52 GMT, Hans Forbrich <fo******@yahoo.net> wrote:

bs********@mylxhq.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