Hextoraw and rawtohex

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