Can I download a file from the internet using a Java Stored Procedure?
407338Jan 30 2008 — edited Jan 31 2008Hi gurus,
I have a requirement to download an xml file from a partner's web site (not secured) and I need to do it automatically once a day at 3 am. Then I need to process the xml file and update or insert into a table. I am thinking about using Java stored procedure and then run it as a job. Does the Oracle database allow access to the internet to download a file? Or do I need to create a little Java program and run it outside the database to do this?
Could someone also give me some sample code for the download? I have never done that yet. Thanks a lot!
Ben