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

[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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org