Hi Vladimir,
thanks,I did the same thing you have mentioned.i have a hexadecimal
value in a very big dat file ,i have to load it into a RAW(16) column
in a table.i have used HEXTORAW as well.Though the sql loader says that
it has reahed commit point.,there is no data loaded into the table.
And so i posted th e query in the groups.
Thanks.
Sorna
On Jan 24, 9:11 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
> 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.comDon'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- Hide quoted text -- Show quoted text -
Received on Wed Jan 24 2007 - 23:36:18 CST
