Hi,
I have table xml_test(id int, res_xml clob); res_xml column has xml data.
I tried to retrieve xml node value from the res_xml column but I getting the fallowing error. Pls guide me to solve this issue
The above error is occurred due the fallowing "¿ ¿¿¿¿ o" junk characters.
I got the result using replace(res_xml,'¿ ¿¿¿¿ o','') in the query. I would like to replace any junk characters as empty. Kindly help me to do this.
Thanks in Advance.