I have a table which contains a BLOB type as field. I have queried
the same table using select statement i got the following error.
Inconsistent Data type.
Could any one tell me the query for getting the value of this BLOB field.
refer to dbms_lob package
Query with SQLPLUS, if that was the case you must be kidding!
How do you expect SQLPLUS shows you BLOB...
try using the DBMS_LOB_READ package might take you nearest to the reading the data from database.
Click Here to Expand Forum to Full Width