i have use QUERY_TO_XML function in order to export data to xml , after that i want to import this data. this data might contain reserved chars in the xml tags like "** ' & ** ..."
ex <position> 'electrical **'** engineer' </position> // contain **'**
i am using xpath to extract the data into temp table then inserting this data to the receiving table by the use of the temp table. what to do in order to escape this characters while using xpath.
i tried function like xmlparse , quate_nullable but it didn't work
No comments:
Post a Comment