I am facing a very unusual problem.
In our stored package procedures we use XML_DOC**.extract(xpath).**getStringVal() to read xml tag values from XML documents.
Problem is, when our package is called through the ESB some tag values are not read. We get NULL.
But if we use the same XML and run as a SQL script, the tag is read correctly.
Could this be some type of bug in Oracle .extract function??
DB is 11g Enterprise Edition Release 11.2.0.4.0