Skip to Main Content

DevOps, CI/CD and Automation

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!

getstringval returns > and not >

34213Mar 13 2008 — edited Mar 14 2008
I am doing this:
L_IMPORT_XML VARCHAR2(10000);
L_XML_TYPE XMLTYPE;

L_XML_TYPE := XMLTYPE(L_IMPORT_XML);

L_IMPORT_XML has the following XML in it
<NOC_ITEM>
<NCB_CODE>1></NCB_CODE>
</NOC_ITEM>

L_NODE_VALUE := L_XML_TYPE.extract('//NOC_ITEM/NCB_CODE/text()').getstringval();

This returns 1&gt; and not 1>

How do I get this to return 1>
or
How do I get
L_XML_TYPE := XMLTYPE(L_IMPORT_XML);
to keep it as > and not convert it to &gt;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2008
Added on Mar 13 2008
2 comments
3,887 views