title: How to pull data from an external source (REST API) with Oracle SQL?
body: <p>I'm evaluating the possibility of pulling XML data from an external service (REST API) over the internet by using Oracle SQL DBMS_Scheduler. This would ideally be an automated solution running on the database server. Is this technically possible and what would be the recommended way for implementation?</p>
  
  <p>Traditionally to have such process automated, I would need a dedicated server that pulls data from the external service and pushes that data further into SQL tables.</p>
  
  <p>I'm trying to come up with a solution where the dedicated server is replaced with DBMS_Scheduler or similar, and the data would be pulled directly into the database.</p>