Skip to Main Content
Forums

Database Software

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!

how to import xml data from a http site with PL/SQL

cacodriMay 20 2015 — edited May 22 2015

Hello,

I have created a table with an XML field as follows:

1. Register Schema "Ordenes"

2. Create the table "Ordenes"

3. imported data into the "Ordenes" table from string data.

Everything works perfectly fine, but I need insert data directly from a URL like this

http://api.mercadopublico.cl/servicios/v1/publico/ordenesdecompra.xml?fecha=02022014&ticket=F8537A18-6766-4DEF-9E59-426B4FEE2844

in Attachment I include codes

Please can you help me with the solution.


Thank you very much
This post has been answered by odie_63 on May 20 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2015
Added on May 20 2015
#performance-availability, #xml-db
4 comments
1,252 views