Re: loading raw datatype with sql loader

On Jan 24, 3:44 pm, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:
> On Jan 24, 3:56 pm, v.so..._at_gmail.com wrote:
>
> > Hi
> > how to load hexadecimal data into raw(16) column in table using sql
> > loader.Define the input as CHAR(32), like this:
>
> load data
> infile whatever
> into table mytable
> (
> ....
> my_raw_field CHAR(32)
> ....
> )
>
> Oracle will automatically convert hexadecimal representation to RAW.
> You can also use HEXTORAW() function explicitly in control file:
>
> my_raw_field CHAR(32) "HEXTORAW(:my_raw_field)"
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com

Don't you think the OP could have found that easily himself, and he was just lazy?
Please discourage such behavior and don't respond to RTFM questions!

-- 
Sybrand Bakker
Senior Oracle DBA