Hi,
Env: Oracle 11g R2 DB
Really hoping someone can assist but I have a requirement to automatically downloading a CSV file located over a http url (say http://example.com/rules.csv) and load the whole contents into an Oracle table, within a BLOB column.
Using a REST API GET, which will be triggered by a DB scheduled job, I am able to get to the CSV filename, which is all working fine.
From this point, I am not sure how to access the contents of this CSV file and insert it's contents into a BLOB column, within the same database?
Any help on how to achieve this using pl/sql would be much appreciated.
Thanks.
Tony.