Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Inserting data based on email attachment
Hi All,
Thank you very much for your suggestions, will give it a shot.
Thanks
- sandeep
On Apr 30, 11:54 pm, "Vladimir M. Zakharychev"
<vladimir.zakharyc..._at_gmail.com> wrote:
> On Apr 30, 1:47 pm, sandeep <hyd.sand..._at_gmail.com> wrote:
>
> > Hi everyone,
>
> > I have a requirement where in I have to detect an incoming mail,
> > download the attachment which is a flat file containing some data,
> > then i have to insert in to oracle tables. I just want to find out
> > whether identifying an incoming mail and downloading the attachment
> > can be done using a windows batch program, so that i can convert the
> > flat file to oracle rows. Please correct me if my approach is wrong,
> > and any sites for the sample windows batch programs would be great.
>
> > Thanks
> > - Sandeep
>
> You can do this easily with a Java stored procedure: load JavaMail API
> into the database and use it to check/fetch email, and then parse the
> received flat file in Java or in PL/SQL, or even by offloading the
> received file to disk and accessing it as an external table. Or, as
> Mladen suggests, write a Perl script that will do the same externally.
> Or try Windows PowerShell. Plenty of choices, whichever is the easiest
> for you will do.
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Received on Mon Apr 30 2007 - 22:15:57 CDT