Chain of update
Hi everybody,
I have these 3 update statements
-- table KID_XML_GTT is
-- table_xml sys.xml_type,
-- validate_message long,
-- validate_status varchar2(10)
--- Clean my XML, remove null tags
UPDATE KID_XML_GTT
SET TABLE_XML =
(DELETEXML (TABLE_XML, '/parts/part//*[.=""]', G_NSPACE_PATH));
--- Validate the cleaned xml against a XSD document
UPDATE KID_XML_GTT
SET VALIDATE_MESSAGE = SCHEMAVALIDATION (TO_CLOB (TABLE_XML), L_XSD);
--- Get standard status from validation
UPDATE KID_XML_GTT
SET VALIDATE_STATUS = GET_STATUS (VALIDATE_MESSAGE);
I'm wonder if it is possible to write all 3 statements in only 1.
0