Re: Receiving email into pl/sql

From: DA Morgan <>
Date: Wed, 07 Nov 2007 13:17:01 -0800
Message-ID: <>

Lee wrote:
> I've sent email from pl/sql with utl_smtp and with 10g's utl_mail; but
> now I want to do the inverse, i.e. I want to READ email from pl/sql.
> The idea is to set up a dedicated email account. Users could send
> stereotyped messages to that account, and the pl/sql routine would read
> the mail, parse the messages and do the needful.
> As far as I can tell, utl_mail will send, but not receive email.
> I can think of some Rube Golberg workarounds but can anyone point the
> way to a "no fuss" way to read simple text emails?
> Thanks in advance

[Quoted] If you think it is a good idea to send emails, across the web, from some Microsoft Outlook client directly into an Oracle database I am sure we can recommend a good 12 step program for you.

[Quoted] Incoming emails are stored somewhere. Find the location. Read them using anything from UTL_FILE to whatever.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Nov 07 2007 - 22:17:01 CET

Original text of this message