based on public data published on some website.If the data is "published on some website", why don't you just use UTL_HTTP to download the file?
The question is, what are the possible ways to ftp these files into my database.
Seenu001 wrote:I use the FTP package described in your link. It works well and doesn't need to use the file system.
Hi All -
I am developing a small website using APEX 4.2 which has backend database that has 10-12 tables. All these tables have to be populated on daily basis based on public data published on some website.
The question is, what are the possible ways to ftp these files into my database. I donot have access to the oracle file system to use the UNIX ftp program to copy the files into Oracle directory and then do a PLSQL API which is explained in http://www.oracle-base.com/articles/misc/ftp-from-plsql.php. Please share your thoughts.