Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unsupported data type in pivot query

VictorCSep 16 2013 — edited Oct 2 2013

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2013
Added on Sep 16 2013
7 comments
1,107 views