how can I process an email inbox in pl/sql

stirus
stirus used Ask the Experts™
on
automated email notifications will go to a particular email.  I'd like to read the inbox, process the email, and then delete it.  these are small emails--less than 2k.  What is the easiest way to do this from pl/sql?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012
Commented:
there is no built in functionality for reading email in Oracle.  Only sending email.

You can however implement your own pop3 client using utl_tcp  package.

this question from the AskTom (Tom Kyte) site has a start on such a procedure


http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:952039400346097108

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial