0 Replies - 1888 Views - Last Post: 09 July 2012 - 04:33 AM

#1 jone kim  Icon User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 46
  • Joined: 07-January 10

The query fails because all columns types are currently not supported

Posted 09 July 2012 - 04:33 AM

CREATE TABLE EMP(NAME VARCHAR2(10 BYTE))
INSERT INTO EMP VALUES ('C');
INSERT INTO EMP VALUES ('A');
INSERT INTO EMP VALUES ('T');

SELECT xmlelement("NAME",NAME) FROM EMP;

I am trying to convert column data to xml format. but I got the error:

Quote

The query fails because all columns types are currently not supported.


I am using SQLTools 1.5.0 Beta build 9 as editor
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production

Is This A Good Question/Topic? 0
  • +

Page 1 of 1