I'm trying to insert a raw value into a raw datatype, that also have another raw files. But don't know why i'm getting the next error:
MY INSERT:
>INSERT INTOTEST (ID) VALUES ('67C1z1ACAzCz11z1B36FA6636166709B');
INSERT INTO TEST (ID) VALUES ('67C1z1ACAzCz11z1B36FA6636166709B')
*
ERROR at line 1:
ORA-01465: invalid hex number
MY TABLE:
>desc TEST
Name Null? Type
----------------------------------------- -------- ------------
ID NOT NULL RAW(16)
TIME NOT NULL DATE
ITS VALUES:
>select Id from test;
SEQ_ID
--------------------------------
5D858698ZSFD55Q5859F9ZC26555599B
535Z8586ZSFD55S5B3879BC26555775B
D3C5S5ZCZSCS5ZS5B38FZ6836568989B
F9C5S5ZCZSCS5FS5B38FZ6836298999B
I googled and read that i have to convert hex to raw, but i only get another error:
>INSERT INTO TEST (ID) VALUES (rawtohex('67C1z1ACAzCz11z1B36FA6636166709B'));
INSERT INTO TEST (ID) VALUES (rawtohex('67C1z1ACAzCz11z1B36FA6636166709B'))
*
ERROR at line 1:
ORA-12899: value too large for column "TEST"."ID" (actual: 32, maximum: 16)
*same if i try with utl_raw.cast_to_raw
what can i do?