Example: Simple XML Import From Application Table

See Also

Here is an example of a simple XML import. This XML import processes the xml_document column for all records in the XML_IMPORTS table that have not been processed yet. The SELECT statement may retrieve zero or more records with an XML document to be processed:

INVOKE    XML.Import

WITH

SELECT     xml_document XmlDocument

FROM     XML_IMPORTS

WHERE     processed = 'N'

For example, suppose a record in the XML_IMPORTS table contains this xml_document:

<Persons>

   <PERSON ID="112" FAMILY_NAME="Smith" FIRST_NAME="John">

       <Update ID="112" FAMILY_NAME="Smith" FIRST_NAME="Johnny"/>

   </PERSON>

</Persons>

For this xml_document, the XML import method will update the corresponding PERSON record.