Prev Up Next
xml_set_ns_decl Home xmlsql_update

Name

xml_view_schema — returns an XML schema for the output of given XML VIEW

Synopsis

varchar xml_view_schema ( in query varchar ,
in root_element varchar );

Description

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.

Parameters

query

a string which contains a name of XML view

root_element

a string containing the element name in which the XML schema would be wrapped

Return Types

XML Schema

Errors

Table24.133.Errors signalled by

SQLState Error Code Error Text Description
42000 No XML view [view_name]

Examples

Example24.524.Creating an XML Schema 


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.

Prev Up Next
xml_set_ns_decl Home xmlsql_update