The <tt>DBWSBuilder</tt> utility requires a DBWS configuration file as input. Note that <code>returnType</code> is set to <code>SOMEPACKAGE_ARECORD</code>; this value indicates a complex type in the schema, which is constructed based on (in this case) the contents of the package <code>SOMEPACKAGE</code>. The generated schema would contain complex types for each type in the package, i.e. <code>SOMEPACKAGE_TBL1</code> <code>SOMEPACKAGE_TBL2</code> <code>SOMEPACKAGE_ARECORD</code>. <source lang="xml" enclose="div">

<?xml version="1.0" encoding="UTF-8"?>

<?xml version="1.0" encoding="UTF-8"?>

<dbws-builder xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<dbws-builder xmlns:xsd="http://www.w3.org/2001/XMLSchema">

Revision as of 13:14, 10 June 2011

EclipseLink DBWS Service based on Stored Function with complex PL/SQL arguments

The use-case for this example is the creation of a Web service that exposes a simple Stored Function containing complex PL/SQL arguments.

The DBWSBuilder utility requires a DBWS configuration file as input. Note that returnType is set to SOMEPACKAGE_ARECORD; this value indicates a complex type in the schema, which is constructed based on (in this case) the contents of the package SOMEPACKAGE. The generated schema would contain complex types for each type in the package, i.e. SOMEPACKAGE_TBL1SOMEPACKAGE_TBL2SOMEPACKAGE_ARECORD.