Getting disconnected from Oracle when querying XMLTYPE column

[Dwayne]

Hi there,

I've been able to reproduce this on several workstations, and consistently.

I have a table with an XMLTYPE column, and when I simply do a "SELECT *" from that table, I consistently get disconnected from Oracle (ORA-3114). Doing the same thing from SQL*Plus works fine.

If I do a Right-Click -> "Query Data" it is also fine. That's evidently because when it builds the query it does not select the XML column, but rather my_xml_column.getclobval(), which works perfectly fine.

Has anyone else seen this?

 

[T-Gergely]

Of course. It's a longstanding problem. There are a few topics about it: you can use the "Search" function to find them.
Here's my latest one.

Alas, it seems there is not a lot of interest in supporting XMLTYPE.

 

[Dwayne]

Hi there,

Thank you for the reference to your post - I'm not sure why my initial search didn't come up with that.

Either way, it's disappointing that AllRound has chosen not to give this any attention. I've got 20 developers that I now have to explain this special treatment of one table to.

Fingers crossed that they'll hear our requests.