I have a select statement that uses a LONG datatype in the where clause and is producing the following error
Error on Select - ORA-00932: inconsistent datatypes: expected NUMBER - got LONG :-932
I tried converting the LONG to a clob using the TO_LOB (see below) and I'm getting the following.
Error on Select - ORA-00932: inconsistent datatypes: expected - got LONG :-932
Can anyone help?
to_char(current_date, 'DD-MM-YY') As Today,
count( CONTHIST.ACCOUNTNO )
trunc(CONTHIST.CREATEON) = trunc(sysdate)
to_lob(CONTHIST.NOTES) not like '%Content-type%'
CONTHIST.USERID IN ('SMITHS1')