7 Replies Latest reply: Oct 2, 2013 12:53 PM by VictorC RSS

    unsupported data type in pivot query

    VictorC

      Hello, I'm trying to do a pivot query, but I am getting [unsupported data type], instead of having returning values

       

      here is my query

        

      WITH pivot_data AS (

                  SELECT DEPARTMENT,CS_GROUP AS "CS GROUP",CS_GROUP

       

       

                  FROM  TABLE1  where PER = 'NAB' and department not like 'SD%'          )

                

         SELECT *

         FROM   pivot_data

         PIVOT XML(

                     COUNT(CS_GROUP)

                     FOR DEPARTMENT          

                     IN  (SELECT DISTINCT DEPARTMENT FROM PIVOT_DATA))

      ORDER BY 1

       

      and the return value looks like this

       

       

      CS GROUPDepartment_xml
      DEVl[unsupported data type]
      PCT[unsupported data type]

       

       

      any ideas why this is happening? I am on oracle 11g and apex 3.2.1

      Thanks.