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.