The error ORA-00932: inconsistent data types occurs when Oracle Database encounters a mismatch in expected data types during execution. The issue arises with the SELECT * query in Oracle Application Express (APEX) when the SQL TEXT field is dynamic.

Try use DBMS_SQL for Dynamic Queries.

Another test you can do to identify the column is to select COLUMN from table until you find the column with the problem in the data.