SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

reading xls files from a ftp server and putting into database

ravikumar.svMar 17 2010 — edited Mar 17 2010

Hi All,

Here's my db details

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

I have a requirement where we will be receiving xls reports(not csv) in a ftp server and we need to read their data and put them into a oracle table as and when we receive. And this needs to be done automatically.
Can it be done using pl/sql?
I even checked jXLS api used for reading excel data...But I don't want to use java unless until it is required and pl/sql cannot do the same.
Can anybody point to some links or provide some info on how to achieve the same?

Best Regards,
Ravi Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2010

Added on Mar 17 2010

8 comments

5,954 views