Re: Receiving email into pl/sql

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

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.

Incoming emails are stored somewhere. Find the location. Read them using
anything from UTL_FILE to whatever.
-- 
Daniel A. Morgan
University of Wa****ngton
damorgan@[EMAIL PROTECTED]
 (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org