Example: Constraint Processing an XML Import
Here is an example of a constraint that calls the XML import method, and processes the xml_document column in the XML_IMPORTS table. This table is also the transition table.
The column values to be imported must NOT be checked against the IO format of the corresponding domains. This is specified by the UseIOFormats parameter.
SELECT OLD(xml_document) XmlDocument
, 'No' UseIOFormats
If a record in the XML_IMPORTS table is updated or deleted, the old value for the xml_document column will be imported.