APEX

Hi,

I am working on the project where my requirement is to retrieve the all emails from the Google App's Gmail inbox and stores into Oracle tables.

My development platform is :

Google Apps - Gmail service
APEX 4.1 / 4.2
Oracle 11g Xe

I've gone through no. of post but didn't found any pure pl sql based method or something which we can call from the oracle procedure/functions.

As it's Oracle XE as database , not supporting Java which is mentioned as one alternative in some posts.

I've tried code some one post as pop3 method implementation, but is not working and only returning out put back is :
pop3:pop.gmail.com port:995

Even not found any thing like web service like approach by Google Apps which we can call. I'd worked on the Google apps provisioning API which supports to post and get values via XML requests & response.

So please help me if some one already done this . I've apex application, so if pure plsql code is not possible but something which can achieve from apex application then that will also works for me.

I'll appreciate prompt response.

Thanks & Regards,
Jaydipsinh Raulji

Skype: jpraulji
Web: [www.oracleapexconsultant.com|www.oracleapexconsultant.com]