RE: RAW insert problem

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 15 Jun 2004 09:20:38 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AB8B@usahm018.exmi01.exch.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tim Gorman Sent: Monday, June 14, 2004 10:28 PM
To: oracle-l_at_freelists.org
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_at_MetraTech.com 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jun 15 2004 - 08:18:00 CDT