Error using TO_LOB on LONG RAW field in select statement

Hi!

Is it possible to convert a LONG RAW field to a BLOB and then use utl_raw.cast_to_varchar2 like below. I get followiung error.

 select utl_raw.cast_to_varchar2(dbms_lob.substr(TO_LOB('long raw field'),10,1)) from t

ORA-00932: inconsistent datatypes: expected - got BINARY

Thanks in advance

// Mats Received on Tue Sep 16 2003 - 09:40:52 CDT