Oracle Long Raw Problem.

Posted by oraclee on Stack Overflow See other posts from Stack Overflow or by oraclee
Published on 2010-04-15T09:20:41Z Indexed on 2010/04/15 9:23 UTC
Read the original article Hit count: 430

Filed under:

Hi All;

select  utl_raw.cast_to_varchar2(DCFILE) hexchar from T_FILE

ORA-00997: illegal use of LONG datatype

select  to_char(DOC_FILE) hexchar from T_DOC_FILE

ORA-00932: inconsistent datatypes: expected CHAR got LONG BINARY

My column type long raw, how to make varchar2 ?

© Stack Overflow or respective owner

Related posts about Oracle