This function return an XML schema for the output of given XML VIEW. The returned schema will be valid if the HTTP_... output of view wrapped into the specified root element.
XML Schema
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| 42000 | No XML view [view_name] |
SQL> select xml_view_schema ('cat', 'root');
callret
VARCHAR
_______________________________________________________________________________
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:annotation>
<xsd:documentation>
Schema of XML view 'cat'
</xsd:documentation>
</xsd:annotation>
<xsd:element name="root" type="root__Type"/>
<xsd:complexType name="root__Type">
<xsd:element name="category" type="root_category_Type" minOccurs="0" maxOccurs="unbounded"/>
</xsd:complexType>
<xsd:complexType name="root_category_Type">
<xsd:attribute name="CategoryID" type="xsd:string"/>
<!-- <xsd:attribute name="CategoryID" type="xsd:int"/> -->
<xsd:attribute name="description" type="xsd:string"/>
<xsd:element name="product" type="category_product_Type" minOccurs="0" maxOccurs="unbounded"/>
</xsd:complexType>
<xsd:complexType name="category_product_Type">
<xsd:attribute name="ProductName" type="xsd:string"/>
</xsd:complexType>
</xsd:schema>
1 Rows. -- 9 msec.