Error when trying to convert LONG RAW to VARCHAR2
I am getting ORA-00997: illegal use of LONG datatype when attempting to run the select statement below.
select dbms_lob.substr(c.blob_contents,dbms_lob.getlength(c.blob_contents),1)
,dbms_lob.getlength(c.blob_contents)
from ce_blob c
where c.compression_cd = 728 and c.blob_length > 0 and rownum <= 1;
I had verified that the data type of c.blob_contents column is LONG RAW. Does anyone see why this error is happening and how to resolve it? I just simply want to convert c.blob_contents to varchar2 format. Thank you!