RE: RAW insert problem

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 15 Jun 2004 09:20:38 -0400

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
-----------------------------------------------------------------

Other related posts: