1 Reply Latest reply on May 24, 2018 12:56 PM by Nicole Apostola

    Query Manager - inconsistent datatypes CLOB

    Jane2018

      I've added a field in Query Manager on PT 8.55.12, ELM 9.2 PUM 16 Oracle Database that is defined as CLOB in the database. The query throws an error:

       

      A SQL error occurred. Please consult your system log for details.

      Error in running query because of SQL Error, Code=932, Message=ORA-00932: inconsistent datatypes: expected - got CLOB (50,380)

       

      In a normal query I would use TO_CHAR()  to convert it but how do I do that in Query Manager? Any help is much appreciated!