Skip to Main Content
Forums

DevOps, CI/CD and Automation

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!

loading xml data from url into oracle table.

Gor_MahiaNov 20 2018 — edited Dec 6 2018

Hi,

loading xml data into oracle table.

I am trying to extract xml data from url into oracle table but the challange iam having is due to the full url doesnt contain actual xml file with extension instead its like ALIAS

e.g,

https://api.e-builder.net/eBoDataAPI.svc/Forms_CO.

iam wondering if there is a way i can automate download into the server location as xxx.xml files then point Oracle to crab them into the Tables

pastedImage_1.png

pastedImage_0.png

any suggestion please.

thanks.
Comments
Post Details
Added on Nov 20 2018
#pl-sql-xml-programming, #xml
3 comments
1,317 views