Hi all,
I am using the table 'childtable' with column 'c1' datatype clob.
Inside this c1 column, i am storing the value in a huge string separated by comma(,)
Example:
| id | c1 |
|---|
| 1 | 123,456,789,908,765 |
| 2 | 6359,1258,12,365 |
My requirement is like,
select * from basetable BT where CodeCombi in (select c1 from childtable CT where CT.id=BT.id )
On executing the above query , Im getting the following error:
ORA-00932: inconsistent datatypes: expected - got CLOB
00932. 00000 - "inconsistent datatypes: expected %s got %s"
In my case c1 column will contain a huge string seperated by comma whose length can be more than the varchar2 default length.
How to achieve this?
Regards,
RM