I am having a table which have three columns in it:
Table name: UserMaster
Column1: UserID
Column2: UserName
Column3: BackUpUsers (CLOB Type)
When i wrote a query like below it is working correctly:
select * from UserMaster where UserID IN (1,2,3 )
But when i fetch this value from BackUpUsers, it throws an error:
select * from UserMaster where UserID in (select BackUpUsers from UserMaster where UserID = 1)
The above inner query return the value 1,2,3 but of CLOB type.
It throws error like below:
ORA-00932: inconsistent datatypes: expected - got CLOB
00932. 00000 - "inconsistent datatypes: expected %s got %s"
*Cause:
*Action:
Any help or suggestion will be helpful..