Oracle SOA & AIA: Extract Composite Audit Trail from database table as XML

Ever wanted to extract XML directly from the SOAINFRA database without using the Java API?

In my case
Problem:
Now and then BPEL instance will fail invoking external service complaining that the service is unreachable. But actually the service is up and running without any problem.
Assumption:
The XLM data is corrupted, it might contain some special hidden character not visible in EM or XML extracted using Java API.
Check:
I want to get the XML from the database and check if this is true.


Thanks to
Oracle SOA & AIA: Extract Composite Audit Trail from database table as XML