Re: ... (design issue) ... Re: How to send a mail in PL/SQL

: However, I would appreciate some advice on how to design a mail system where
: the messages will not be lost (I believe that DBMS_PIPEs lose their data if
: the server goes down).

Store the messages in a table in a long field (should please your DBA :)) in a table and have a daemon process periodically scan the table for new mail messages.

You could use dbms_message/dbms_alert to notify the daemon of new work as well as getting it to scan the table periodically for new work. Seeing as you are using email, I suspect that your application is not exeactly timecritical,  so maybe just get the daemon to scan the table every 'x' minutes and don't bother with the dbms_* side of things.

You would probably want to crank up the security on this table to ensure that the text of the email is not readable by all. A simple form of encryption could be written in PL/SQL (the source of whoch could be wrap'd) and called to encode/decode the mail messages.

IAP

--
In an attempt to reduce junk email I use an invalid 'From' address.
My correct email address can can be determined by replacing 'not.valid' with 
'value.net'