OraFAQ Forum: JDeveloper, Java & XML » how to use sql to bypass xml special character? Please....:)

Home » Developer & Programmer » JDeveloper, Java & XML » how to use sql to bypass xml special character? Please....:)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to use sql to bypass xml special character? Please....:) [message #558259]

Wed, 20 June 2012 07:51

ocs2me
Messages: 2
Registered: June 2012

Junior Member

"SELECT xmltype(RCATT).extract('/JASON/RCA/SUB_PROBLEM_TYPE').getStringVal() as SPT,
xmltype(RCATT).extract('/JASON/RCA/SUB_ROOT_CAUSE').getStringVal() as SRC,
xmltype(RCATTT).extract('/JASON/RCA/ELABORATION').getStringVal() as ELA,
xmltype(RCATT).extract('/JASON/RCA/PREVENTION').getStringVal() as PRE
FROM table"

ABove is my select starment

some explanation:
the above select statement is to select the child node inside the xml content.
But the child note contains some special character "<>" that illegally in xml.

Below is my xml content for the node of sub_problem_type

<JASON>
<RCA>
<SUB_PROBLEM_TYPE>
For <FS_PLS_WAIT>, it is appeared in both valid and invalid password entered case but in requirement, only valid case has stated the display of <FS_PLS_WAIT>. This is the legacy radio behavior.
</SUB_PROBLEM_TYPE>
</RCA>
</JASOn>

The result will generate the following issue.

ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00225: end-element tag "ELABORATION" does not match start-element tag "FS_PLS_WAIT" Error at line 10 ORA-06512: at "SYS.XMLTYPE", line 301 ORA-06512: at line 1

I wish to know where can i by pass the checking for special character

Report message to a moderator