Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML_DOC.extract(xpath).getStringVal() does not read tag value when run through ESB

SebaVastaOct 20 2021 — edited Oct 20 2021

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

This post has been answered by Paulzip on Oct 21 2021
Jump to Answer
Comments
Post Details
Added on Oct 20 2021
10 comments
655 views