Load Data into Oracle from web service call

Please check my scenario below and recommend options to load data into Oracle 10g database.

I have a external vendor that will provide data via a web service call. Which means i can access data residing on a extranet website by making a web service call. I need to know how to integrate this call into Oracle ? I mean I want a feature within Oracle 10g that accepts a web service call and "somehow" pulls that data from the web service call and import that data into our oracle table ( 1 table for now).

Your answers are much appreciated.
Who is Participating?
gatorvipConnect With a Mentor Commented:
There's no single answer to this, as there are many different approaches. What kind of web service do you deal with? Is the "call" supposed to insert data into a single table?

Here are a couple articles describing how to consume data via SOAP
vemi007Author Commented:
I do not have many details yet, I am expecting that the web service provides functionality to pull data from the remote site. Data will be sent in an XML format which is accompanied by an XSD document to parse the document.
vemi007Author Commented:
Lists part of the options that  am looking for hence grade B.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.