This content has been marked as final. Show 6 replies
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.
If the file is on a web site, you would need to use HTTP to access it. If the file is on a FTP server, you would need to use FTP to access it. When you click the link to download the file, are you sent to an HTTP:// address or a FTP:// URL?
You may be able to use the UTL_COMPRESS package to unzip the ZIP file once you download it-- see, for example
Personally, though, I'd find it easier to write a Java stored procedure to do that. There are way more examples and far more complete libraries for working with ZIP files in Java.
Once you've unzipped the ZIP file and extracted the file, you'll have to write code to parse the file and load the data into your table.
Of course, all this would be dramatically easier if you had access to the operating system functions on the server. Then you could simply download, unzip, and parse the file as part of an external table definition with a preprocess step doing all the heavy lifting.
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.