I have an Oracle table that includes a column that has an XMLType data type. I store XML in that column in the table.
When I "select * from" the table it shows me the rows and columns in the table. It shows the XML column as "". When I click the "..." next to it, a popup appears showing me the XML. So far so good. That's how it is supposed to work.
Now I close the popup and "select * from" the table again, it shows some of the XMLTYPE columns as "" but in purple cells. If I click on the "..." it opens a popup to show me the XML again but there is no XML shown. I know there is XML in the column because I just saw it, but it almost seems like it allows you to view the XML once and then freaks out if I try to see it a second time.
What does a purple cell mean? Is this a bug or am I misunderstanding how this works?
When I "select * from" the table it shows me the rows and columns in the table. It shows the XML column as "". When I click the "..." next to it, a popup appears showing me the XML. So far so good. That's how it is supposed to work.
Now I close the popup and "select * from" the table again, it shows some of the XMLTYPE columns as "" but in purple cells. If I click on the "..." it opens a popup to show me the XML again but there is no XML shown. I know there is XML in the column because I just saw it, but it almost seems like it allows you to view the XML once and then freaks out if I try to see it a second time.
What does a purple cell mean? Is this a bug or am I misunderstanding how this works?
