Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

ORACLE exchange of data

I need to exchange date between two remote ORACLE 11 XE databases. I will do the testing  over VPN using PL/SQL stored procedure (approx, 100 MB / 24 hours)
Is it supported by 11 XE?
How to use native ORACLE web services for data exchange between two remote site?
Thank you in advance,
Andreja
0
andrejaTJ
Asked:
andrejaTJ
  • 2
2 Solutions
 
slightwv (䄆 Netminder) Commented:
Is there a reason you want to do this with web services?

You can create a database link between the two databases and just query across them.
0
 
andrejaTJAuthor Commented:
This is not a problem, but maybe the client will request... I don't know how reliable the connection are in Asia and INSERT can pass across....
0
 
slightwv (䄆 Netminder) Commented:
I don't believe Oracle has web services 'built in'.  I've seen examples of consuming a web service from PL/SQL but have never played with them personally.

I've not seen any examples where the database itself can expose a web service.  Most of the stuff I've seen out there the web service is created outside of the database.

Straight database to database I believe you need database links.
0
 
sdstuberCommented:
Using APEX you can expose a web service directly from within the database.  SOAP or REST, using the APEX Listener can help setup REST services.

However, I'd go with database links anyway.
Simpler to setup, fewer "moving parts" so should be more reliable.

If you lose connectivity between the databases, then it won't matter if you were communicating by db link, web service, dbms_pipe, utl_tcp, etc.
0
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now