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!
Try an expression like:
In this case, I’ve created an Expression Type of Character, a Length of 2000, and put the following in the Expression Text: TO_CHAR(A.COMMENTS)
Also, keep in mind that you can't use DISTINCT with a CLOB field, nor can you use it over a database link.