Kiem Nguyen wrote:Welcome to the forum: please read the FAQ and forum sticky threads (if you haven't done so already).
I have a classic report with complex queries. I would like to have sortable columns in the classic report. I enable "Sort" in the Report Attributes but I get this message when clicking on the column name to sort: "ORA-00932: inconsistent datatypes: expected - got CLOB" I would greatly appreciate if anyone could help me out.The column data type is CLOB. As described in the SQL Language Reference, you cannot order by a LOB, LONG, or LONG RAW column, nested table, or varray.
Kiem Nguyen wrote:It's not necessarily the data type of the base column, but that produced in the query projection. It's not possible to comment further without full details of the report or a demonstration on apex.oracle.com.
Thanks fac586 for your prompt response. I checked all the tables and I don't see any column with CLOB data type. Do you know why the message "ORA-00932: inconsistent datatypes: expected - got CLOB" keeps showing when I try to sort the column? Thanks.