Unescaping XML entity references within a stored procedure invoked from the Database Adapter (Doc ID 2127086.1)

Last updated on MARCH 27, 2020

Applies to:

Symptoms

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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.