Image

CHAPTER

15

XML DB Web Services

Native Oracle XML DB Web Services simplifies the publishing of database processes; thus, they can be integrated with SOA (Service-Oriented Architecture) applications for data exchange and business process integration. In Oracle Database 11g, we can publish Oracle database SQL queries and PL/SQL procedures as Web Services. In this chapter, let’s learn how to use the native XML DB Web Services feature.

EXAMPLE SETUP

To run examples in this chapter, please first log in as SYS (as SYSDBA) user to grant additional privileges to the XMLDEMO user (grant_ws_ privilege_to_xmldemo.sql):

GRANT xdb_webservices TO xmldemo; ...

Get Oracle Database 11g Building Oracle XML DB Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.