Topic
3 replies Latest Post - ‏2012-02-28T17:57:24Z by MatthiasNicola
VV4H_mario_fernandes
43 Posts
ACCEPTED ANSWER

Pinned topic Use XMLVALIDATE when updating table

‏2012-02-28T16:47:59Z |
Please tell me how to use xmlvalidate while doing the following update.
I want to validate the xml after the value has been updated.
update kasper.xml_client
set xml_client = xmlquery( 'transform
copy $new := $XML_CLIENT
modify do replace value of $new/kasperSchema/TDSClient/venomJmsMessage/sentTime
with 905-477-9011
return $new')
where
XMLEXISTS('$d/kasperSchema/TDSClient/kasperClient/client' passing xml_client as "d")
;
Updated on 2012-02-28T17:57:24Z at 2012-02-28T17:57:24Z by MatthiasNicola