Tuesday, 23 July 2019

SOACS - Convert delimited string to an array of XML elements.

Use following XPATH function to convert/map a delimited string to an unbounded xml element.

Use CopyList rule in assign activity to map the value.

From Value: 

oraext:create-nodeset-from-delimited-string('{http://www.TargetElementNamespace.org}$TargetElement',$InputDelimitedString,'$DelimeterValue')


To Value : 
$Unbounded Target Element Name


$TargetElement  - Unbounded Target Element
$DelimeterValue may be "," or "|" 

No comments:

Post a Comment

Oracle - OCI - Exadata Database

Exadata Database is a scalable, private database server that is completely isolated from other tenants. It can be used to run all database ...