Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to examin BLOB (Long Row) using SQL*Plus?
hi,
I understand that simply doing a 'select' on a field whose type is LONG RAW wil result in the error:
ORA-00932: inconsistent datatypes
using SQLplus. Since SQL plus does not like to display LONG RAW data. (was told anything over 256 bytes in length will result in this error).
My question, is there another trick I can use to, if not display this field, at least find how many bytes are stored in the field?
The reason I need to do that, is to make sure my program that reads these fields is correct by comparing its results with SQL plus results.
thanks!
Nasser
Received on Fri Nov 27 1998 - 00:00:00 CST