Unescaping XML entity references within a stored procedure invoked from the Database Adapter
(Doc ID 2127086.1)
Last updated on OCTOBER 13, 2021
Applies to:Oracle SOA Suite - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
A Database Adapter used by a SOA composite invokes a stored procedure, providing an XML payload as the input parameter.
In the stored procedure, when extracting data from the XML payload, it is found that any entity references within the XML have been escaped.
eg. An "&" ampersand character in the XML will have been escaped to "&"
However the requirement is to have the characters stored in the database in their original un-escaped form.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document