SQL Language (MOSC)

MOSC Banner

ORA-00932: inconsistent datatypes: expected - got CLOB

edited Nov 26, 2015 10:00AM in SQL Language (MOSC) 1 commentAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center