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!