Re: UTL_SMTP and attachments

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 <forbrich_at_yahoo.net> wrote:

>bsc7080mqc_at_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
Received on Mon Jul 12 2004 - 01:22:56 CEST