ORA-00932: inconsistent datatypes: expected - got CLOB
Hi Friends,
The below query gives error
select distinct sql_fulltext from gv$sql;
ORA-00932: inconsistent datatypes: expected - got CLOB
00932. 00000 - "inconsistent datatypes: expected %s got %s"
*Cause:
*Action:
--My main query is mentioned below (Getting Long Running sessions with sql Text) and if i remove distinct i am getting duplicate values which i don't need..
select distinct b.sql_fulltext,a.sql_id,sid,serial#,username,osuser,process,program,machine,LAST_CALL_ET/(60),status from gv$session a,gv$sql b where status='ACTIVE' and a.sql_id=b.sql_id and a.inst_id = b.inst_id;