Use the XSLT_SHRED stored procedure for XML shredding (extracting values from a single XML document to be used to populate the database), and is based on an XSLT stylesheet.
The XSLT_SHRED stored procedure is created under the user TD_SYSXML.
The user invoking this stored procedure must have the following privileges:
- EXECUTE PROCEDURE on TD_SYSXML
- SELECT privilege on the staging table
- GRANT ALL (insert/update/delete/upsert) on the target tables