Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Error using TO_LOB on LONG RAW field in select statement

Error using TO_LOB on LONG RAW field in select statement

From: Mats L <matsla_at_hotmail.com>
Date: 16 Sep 2003 07:40:52 -0700
Message-ID: <2d83b9f.0309160640.90f6a11@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US