471,073 Members | 1,463 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

UTL_SMTP and attachments


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
Jul 19 '05 #1
3 9053
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


Jul 19 '05 #2
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
Jul 19 '05 #3
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


Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jorge Pinto | last post: by
1 post views Thread by nabil m | last post: by
1 post views Thread by Steve Holden | last post: by
1 post views Thread by Anna C. Dent | last post: by
reply views Thread by Ana C. Dent | last post: by
1 post views Thread by Jack Parker | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.