Re: E-mail to Database (Oracle 8i)

Thanks for the thoughts - seems pretty complex!! I had wondered about a tool called procmail for the o/s side of stuff and wanted to see if anyone would mention it. I was probably thinking lower-level, something like procmail then sqlloader (using cron) then pl/sql package running under dbms_job.

Whether procmail is the tool for the job I don't know, more research required!

In article <atmv7l$824$1_at_babylon.agtel.net>, bob_at_dpsp-yes.com did, with immense forethought and due consideration for the subscribers to this newsgroup, say...
> 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
> >
>
>
Received on Tue Dec 17 2002 - 06:19:59 CST