Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: E-mail to Database (Oracle 8i)
Oh, and by the way, you can actually only extract attachments
from the mail and upload mail text and attachments separately
as LOBs and then use ConText/Oracle Text - create an index on
them and use it for searching/extracting keywords, themes, etc.
-- 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. "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:atmv7l$824$1_at_babylon.agtel.net...Received on Tue Dec 17 2002 - 04:47:33 CST
> 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...
> > 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
> >
>