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

Home -> Community -> Mailing Lists -> Oracle-L -> Hextoraw and rawtohex

Hextoraw and rawtohex

From: Linda Hagedorn <Linda_at_pets.com>
Date: Tue, 18 Jul 2000 12:59:46 -0700
Message-Id: <10562.112315@fatcity.com>


Hello,

Does someone have and example of a where clause using hextoraw?

I can get rawtohex to work:
select rawtohex(prod_id) from
bv_ext_prod_vis_history where prod_id like '%811348818%' ;

But hextoraw is failing with this error: SQL> select hextoraw(prod_id) from
  2 bv_ext_prod_vis_history where prod_id like '%811348818%' ; ERROR:
ORA-01465: invalid hex number

Linda Hagedorn

Oracle. It's not x'C4C292'. Received on Tue Jul 18 2000 - 14:59:46 CDT

Original text of this message

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