Re: Receiving email into pl/sql
Date: Wed, 07 Nov 2007 13:17:01 -0800
> 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.orgReceived on Wed Nov 07 2007 - 22:17:01 CET