Re: How to send a mail in PL/SQL

twod_at_not.valid wrote:
>
> David Richardson (drichardson_at_all-4-one.com) wrote:
> : So how does using DBMS_PIPES get you out to the operating system
> : level???? I just don't see it
>
> You have a listener/daemon, written in a language such as Pro*C/Oraperl/foo
> that attaches to the pipe and reads the messages sent down it. The listener
> then does the required action(s) (ie forks a process that does the emailing).
>
> 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'

Yes, I thought as much, I just wanted to see the original answer poster state this. We did the exact same thing exceprt we used DBMS_ALERT and PRO*C/OCI. Pipes have a limit to the amount of buffer whereas with Alerts you can use a table with POST-INSERT trigger to signal alert.

-- 
David Richardson	1-800-425-6719
All 4 One, Inc.		drichardson_at_all-4-one.com
2026 Aquia Drive	http://www.all-4-one.com
Stafford, VA 22554