Re: Read UNIX e-mail from Oracle with PL/SQL?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Tue, 6 Mar 2001 12:46:23 -0000
Message-ID: <983882791.14718.0.nnrp-02.c30bdde2@news.demon.co.uk>

You could use the UTL_FILE package to open /var/mail/<username> and parse directly from there?

"Dave" <fornalskyd_at_mediaone.net> wrote in message news:3aa0204c$0$63743$45beb828_at_newscene.com...
> Hi all,
>
> A big-wig at the client I'm at needs to check his e-mail
> while he's off site using a wireless device, most likely
> a Palm OS handheld. We've discussed a number of ways but
> for various reasons they've all been shot down.
>
> The latest and greatest idea has been to build a simple
> web interface to the e-mail account. This solves a number
> of technical hurdles (and many other security and
> political hurdles) and using PL/SQL would be easy to
> create. Think something like Yahoo mail.
>
> Sending e-mail would be no trouble, but how can I access
> this user's UNIX e-mail account (Sun/Solaris) from Oracle
> with PL/SQL so that I can read his messages and present
> them in the Web interface? Any ideas? Can this be done
> and is there any sample code out there I can be pointed
> to? Using Oracle8i 8.1.6 and Oracle Web Server 2.1.
>
> Thanks for any help!
>
> - Dave
>
>
Received on Tue Mar 06 2001 - 06:46:23 CST