3 Replies Latest reply on Dec 6, 2018 10:57 PM by Jason_(A_Non)

    loading xml data from url into oracle table.

    Gor_Mahia

      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

       

       

       

      any suggestion please.

       

      thanks.