Harvinder, if you have the '0X' in your field and cannot filter it to use the functions as Tim demonstrated you can use replace or substr to eliminate the '0x' from your data: 1* select rawtohex(hextoraw(replace('0XABCD','0X',''))) from dual UT1 > / RAWT ---- ABCD HTH -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tim Gorman Sent: Monday, June 14, 2004 10:28 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: RAW insert problem SQL> select rawtohex(hextoraw('0Xabcd')) from dual; select rawtohex(hextoraw('0Xabcd')) from dual * ERROR at line 1: ORA-01465: invalid hex number SQL> select rawtohex(hextoraw('abcd')) from dual; RAWT ---- ABCD on 6/14/04 3:57 PM, Harvinder Singh at Harvinder.Singh@xxxxxxxxxxxxx wrote: > Hi, > > Our application is trying to insert value 0Xabcd in the column of > datatype raw but oracle is giving error: > Comma not found > How can we convert convert this column into RAW and insert into column > > Thanks > --Harvinder > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------