ORA-00997: Illegal use of LONG datatype

[beatlejus]

Hi,

I am just trying this query:

select distinct
iasmatfms.statmatnum,
iasmatx.stext,
iasmatx.ltext
from iassalitem,
iasmatfms,
iasmatx
where iassalitem.material = iasmatfms.material
and iasmatfms.material = iasmatx.material
and iasmatx.texttype = 'B'
and iassalitem.customer = '10211780'

where the use of iasmatx.ltext causes the error message. Is there any solution to use this field without having the error?

 

[Marco Kalter]

You cannot use a long column in a DISTINCT expression. I don't immediately see a solution.