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

On 4 Jun 1997 17:29:24 GMT, twod_at_not.valid wrote:

>: 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 time-
>critical, 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'

[Quoted] If anyone wants to send mail from PL/SQL using 95/NT, I have a solution using the HOST comand and a Freeware DOS SMTP mail program

Reguards

Jas
JASON_at_WAIKATO.AC.NZ for more info Received on Wed Jun 04 1997 - 00:00:00 CEST