Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: E-mail to Database (Oracle 8i)
Looks like nobody have done it. :) I see two possible ways of
doing this: outside Oracle and inside Oracle. Outside means you
will create a program (in Perl, Java or whatever) that will access
mail account, parse and filter mail from it and then upload needed
parts to the database using whatever means available/preferred
(JDBC, OCI, ODBC, etc.) Inside is more portable but will put
additional stress on the database server: you upload JavaMail
API into the VM, write some classes of your own that will use it
to retrieve mail and process it the way you want and then upload
needed data into Oracle tables using KPRB driver. You can then
create PL/SQL wrappers for runner methods of your class(es)
and schedule them using DBMS_JOB to run at regular intervals.
If your database is already busy enough I'd opt for external
approach and run that external program elsewhere only uploading
processed data at off-peak hours, but if you can afford running
the whole thing inside the database - do it, it's so much easier. :)
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Jeremy Ovenden" <newsposter_at_hazelweb.co.uk> wrote in message news:MPG.18679ca5b36e3e4a9896c4_at_news.cis.dfn.de...Received on Tue Dec 17 2002 - 04:42:38 CST
> This actually crosses a few core technologies, but I'd be interested to
> hear if you have ever implemented a system in which incoming e-mails to a
> designated address are 'processed' (I.e. identify keywords and values for
> example) and attachments removed and then data from the e-mail and any
> attachments are loaded into an Oracle 8i database.
>
> Thanks....
>
>
> --
>
> jeremy
>