-
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?
-
Long Raw col value can not be displayed in SQLPLUS.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|