Receiving email into pl/sql

#11

Ana C. Dent wrote:

Quote:

Lee <leeh (AT) panix (DOT) com> wrote in news:fgv7lr$er1$1 (AT) reader1 (DOT) panix.com:

shakespeare wrote:

Back in the nineties, Oracle used to have a product called Oracle
Mail, which was able to receive email (and yes: in the database). It
became part of Oracle Interoffice (which died some years later).
Don't know if it's still around as a product, but it is stil there as
a part of Oracle Collaboration Suite (able to receive mail in the
database). I had a customer who installed Coll. Suite for this
purpose solely: they wanted to be able to start processes based on
email. Installing OCS is quite a fuss, keeping it running even more,
but it may be worth a try. You'll have to pay for it, though.
Oracle Interconnect had an SMTP adapter (but that was in 2001). We
never got it working, iirc it could not handle attachments.Could be
part of BPEL now (does someone know?).

Thanks for the input.

Its beginning to look as if I'm not going to be able to do any
better
than my friend Rube (Golberg) after all.

If you don't mind reinventing the wheel, it would be possible to
write a POP3 or IMAP client in PL/SQL using UTL_TCP.
Both protocols are well defined standards.
This would allow you to pull messages directly into a store procedure

And if you are going to reinvent ... why not just write it in Java?
Or better yet C++ or C ... or better yet Assembly language. Reinvent
all the way back to breadboards if you choose. <g>

Or, of course, spend a few dollars on Collab Suite but that would
be sooooooo boring. <g>
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Receiving email into pl/sql

comp.databases.oracle.tools comp.databases.oracle.tools

Re: Receiving email into pl/sql - 11-10-2007 , 01:52 AM