OracleXMLQuery and xml type columns

Problem: OracleXMLQuery escapes xml if the result set has a column which itself contains xml string.

Description: I have a database view with a varchar2 type column. the column contains xml string. when I use OracleXMLQuery to select data from the view, OracleXMLQuery escapes the xml string.

Solution: I am still looking for the solution, I have tried by changing the column type to XML type, but that also didnt work.

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: