handling of sys.xmltypes

[Jean-Paul Finne]

I have a table TABLE1 with a column INFO of type sys.xmltype.

In a command window, the correct result is displayed:
select id, info from table1;
gives:
1

 

[Jean-Paul Finne]

select * from table1 in a sql Window doesn't display the INFO column.

I'd rather see the INFO column as .
It is very confusing that some columns are invisible.

 

[Marco Kalter]

Oracle Net cannot handle SYS.XMLTYPE columns properly, so they are omitted and implicitly replaced by a getclobval() expression whenever possible. I'm not sure why the Command Window displays them though.

------------------
Marco Kalter
Allround Automations

 

[Jean-Paul Finne]

Please handle sys.xmltype the same way in the sql window as in the command window.

I don't like results with columns that are "magically" removed or modified.

 

[Jean-Paul Finne]

By the way, sqlplus displays XMLTYPES() with the same sql statement.