Re: RAW insert problem

From: Tim Gorman <tim_at_sagelogix.com>
Date: Mon, 14 Jun 2004 20:27:59 -0600
Message-ID: <BCF3BACF.16991%tim@sagelogix.com>

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

Received on Mon Jun 14 2004 - 21:35:17 CDT