APEX

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!

Importing CSV files to Database Backend.

979895Dec 14 2012 — edited Dec 15 2012

Hi,

There is a report that is generated everyday in the .csv file format that i would want to load into the database. I want to completely automate this process.
I don't want to use the load function available in APEX. I use APEX 3.2 Version.
What i mean by automation is that i will create the CSV file and automatically move to a location from which APEX can access the data. I would then write a procedure to fetch the content directly from CSV file and write to the database.
What i need help is the location from which APEX can access data directly ? and some sample code that guides me to copy content from a CSV file to the database..

Thanks a Lot

Mahesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2013

Added on Dec 14 2012

#apex-discussions

1 comment

421 views