ORA-00932: inconsistent datatypes: expected - got LONG

Solution:

I have given here an example:

SQL> select to_lob(t.trigger_body) from dba_triggers t;

select to_lob(t.trigger_body) from dba_triggers t

*

ERROR at line 1:

ORA-00932: inconsistent datatypes: expected - got LONG

SQL> CREATE TABLE TMP_TRIGGER

(

TRIGGER_BODY CLOB

);

SQl> insert into TMP_TRIGGER select to_lob(t.trigger_body) from dba_triggers t;

Now you can do search from table TMP_TRIGGER. So I have converted long to CLOB and inserted into a table since it’s not possible to convert it in select statement.