Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RAWID data type in Oracle 8 - insert statment.

Re: RAWID data type in Oracle 8 - insert statment.

From: <l.heasman_at_gmb.com.au>
Date: Mon, 01 Mar 1999 22:16:10 GMT
Message-ID: <7bf3j1$a18$1@nnrp1.dejanews.com>


Have a look at the built in conversion functions "HEXTORAW" and "RAWTOHEX". If I am correct you are inserting in to a RAW field with normal data. The data first needs to be Hex encoded then converted to raw. Something like; HEXTORAW(RAWTOHEX('data')) It's ugly, but I think that is what you will need to do.

Lachlan

In article <36dbd4fb.35619808_at_news.barak.net.il>,   nospam_at_nowhere.com (Holmes) wrote:
> who can i add new records to a table with the data type RAWID??
> thanks!
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 16:16:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US