I need to extract 5 values from xml fragment stored in one of the varchar column in a table. I m however able to view the 5 values extracted from 1 xml fragment. But when I happen to update all these extracted columns to another table , i m faced with xml parsing error.
How do i identify the problem - is it bcoz of special characteres or invalid xml. How can I identify and resolve this issue . Did any one come across the same -seek help.