ORA-00932: inconsistent datatypes

[fmedina]

i have the next table

SQL> DESC BASE1.BLOBDATA
Name Null? Type
------------------------------- -------- ----
OWNERID NOT NULL NUMBER(10)
LONGID NOT NULL NUMBER(10)
SEGMENTID NOT NULL NUMBER(10)
SEGMENT LONG RAW

when i execute the next query, i receved the error 932

SQL> SELECT *
2 FROM BASE1.BLOBDATA
3 WHERE ROWNUM < 5;
ERROR:
ORA-00932: inconsistent datatypes

i guess is the lon row type

what can i do?

[tamilselvan]

Long Raw col value can not be displayed in SQLPLUS.