Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Load Data into Oracle from web service call

Posted on 2010-11-22
3
Medium Priority
?
678 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:vemi007
  • 2
3 Comments
 
LVL 20

Accepted Solution

by:
gatorvip earned 375 total points
ID: 34192130
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
http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.php
http://www.oracle-base.com/articles/10g/utl_dbws10g.php
0
 

Author Comment

by:vemi007
ID: 34197405
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.
0
 

Author Closing Comment

by:vemi007
ID: 34252625
Lists part of the options that  am looking for hence grade B.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question