1 Reply Latest reply on Dec 23, 2013 2:16 PM by thatJeffSmith-Oracle

    XMLTYPE not working on SQL Dev 4 EA3

    steveswinsburg

      Hi,

       

      It appears that XMLTYPE is still not working correctly in SQL Developer EA4 Version 4.0.0.13 Build MAIN-13.30.

       

      The following produces an XMLTYPE result, but it is not viewable:

       

      SELECT

        XMLELEMENT("root",

          XMLAGG(

            XMLELEMENT("elem", 123)

        )

      ) "XML"

      FROM dual;

       

      This works correctly in SQL Developer 3.

       

      Note that doing a .getClobVal() on that result does give the text string of the XML, so it is a view problem in EA3 that doesnt show the raw  XMLTYPE.

       

      Thanks,

      Steve