| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: E-mail into an Oracle Database
Jon Tilbury wrote:
> Hi,
>
> we are trying to email into and out of an Oracle 8i server. We need to be
> able to receive e-mails into a procedure, read them, save parts of the
> message in the database, compose a reply based on the contents of the
> database, and send it on other users. We don't want to have to use any
> special client software, just software on the RDBMS server.
>
> We can't be the first to try to do this. Anyone any suggestions?
>
> Jon Tilbury
Probably the easiest way to do this (depending on your OS ) is to have the
email
piped or forwarded to a Perl script that will parse it and put it into the
database
Then Query the database for what ever content you want build an email and
send it....
There is an example of a perl script on my website that querys the database
for info
then sends email based on that.
check out www.oralinux.org
Mark
--
Mark Wagner - Cyber Trails Phone - (602)906-1751 Oracle DBA / Systems Administrator Pager - (602)521-4280 mark_at_cybertrails.com Fax - (602)907-1799 * www.oralinux.org * * Evil Lord of the Sysadmin Sith Darth cat*|/dev/audio * --------------------------------------------------------------------Who are you? where are we going? and why are we in this handbasket? Signatures are like bumperstickers for geeks. Received on Fri Dec 10 1999 - 12:39:28 CST
 |
 |