Using an XML Definition Set

The procedure used in this section uses an XML definition set named XMLLib_Composite, which has the following XML schema and elements:

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

<xs:schema elementFormDefault="qualified" 

   targetNamespace="http://www.compositesw.com/services/webservices/system/admin/resource" 

   xmlns:ns="http://www.compositesw.com/services/webservices/system/admin/resource" 

   xmlns:xs="http://www.w3.org/2001/XMLSchema" 

  >

<xs:simpleType name="Location">

<xs:restriction base="xs:string"/>

</xs:simpleType>

<xs:complexType name="Address">

    <xs:sequence>

      <xs:element name="street" type="ns:Location"/> 

      <xs:element name="number" type="xs:integer"/>

      <xs:element name="suite" type="xs:integer"/>

      <xs:element name="phone" type="xs:integer"/>

      <xs:element name="fax" type="xs:integer"/>

    </xs:sequence>

</xs:complexType>

<xs:element name="CompositeAddress" type="ns:Address"/>

</xs:schema>

The procedure described here supplies values to the elements in the XML schema in the definition set XMLLib_Composite (Note: The type elements defined in the wsdltest definition set like TradePriceRequest and TradePrice are also referenced. ).

To use an XML-type definition set

1.

Create a SQL script by right-clicking at an appropriate location in the resource tree and selecting New SQL Script, typing a name for it, and clicking OK.

2.

Type the following script in the SQL Script panel of the script editor:

PROCEDURE ScriptComposite(OUT CompanyAddress /shared/sources/definitionSets/XMLLib_Composite.

"{http://www.compositesw.com/services/webservices/system/admin/resource}Address")

    BEGIN

set CompanyAddress = '<ns:CompositeAddress

xmlns:ns="http://www.compositesw.com/services/
              webservices/system/admin/resource">

    <ns:number>2655</ns:number>

    <ns:street>Campus Drive</ns:street>

    <ns:suite>Suite 200</ns:suite>

    <ns:city>San Mateo</ns:city>

    <ns:zip>94403</ns:zip>

    <ns:phone>650-277-8200</ns:phone>

    <ns:fax>650-227-8199</ns:fax>

  </ns:CompositeAddress>';

    END

3.

Execute the script to see the result.

Top