How to Call WebService from Oracle DB Using UTL_DBWS and Return Results in XML Format

(Doc ID 746455.1)

Last updated on APRIL 11, 2018

Applies to:

Web Services - Version to [Release Oracle10g]
Information in this document applies to any platform.
Oracle Server - Enterprise Edition - Version:
Oracle Server - Enterprise Edition - Version:


This article provides a method for consuming a Document Style Web Service using the UTL_DBWS package.  It calls a web service deployed in Oracle Application Server or later.  The sample will work inside Oracle Database version and  The web service returns the following results:

<ns0:getBrandsResponse xmlns:ns0="">







Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms