TD_SYSXML.AS_SHRED_BATCH ( queryString, annotatedSchema, externalContext, resultCode )
Syntax Elements
- queryString
- An SQL query that returns 2 columns:
- An ID column
- A column that contains the XML document to be shredded as an XML data type
If queryString is NULL, the stored procedure returns a resultCode of 1 without performing any operations.
- annotatedSchema
- An annotated schema that maps the XML document structure to the target tables to update. If annotatedSchema is NULL or is not a valid mapping definition, an error is raised.
- externalContext
- Configuration values used to override equivalent parameters specified in the annotated schema mapping. This must be a comma separated list of name=value pairs and the names must match one of the configuration parameters in the annotated schema.
- resultCode
- A return code where:
- 0 = success
- 1 = failure