Presentation: "Technical: Sending Mail from SQL and PL/SQL Custom Programs"
"
Speaker(s): John Missinne, McKee Foods
At McKee Foods, we needed a way to respond to certain events inside our custom programs in a way that would be hard to ignore. So we looked at the UTL_HTTP and UTL_TCP packages (and several versions of example code) and wrote our own email Sender. We now send simple messages using a SELECT statement, and complex messages with attachments by calling a stored procedure. If you have ever wanted to send email from a custom program, or wondered how to use the UTL_HTTP or UTL_TCP packages, or even if you just like digging into PL/SQL stored procedures, then come join this session.