CODEWITHSUNDEEP
oracle-databasecompiler-errorsbinaryvarbinaryraw
Mouni
Mouni

Reputation: 1

Error while Loading varbinary data into oracle raw column

Create table temp(col raw(40));

Insert into temp values(0x02900000AB45GH38);

Error: ORA-00917: missing comma

Upvotes: 0

Views: 89

Answers (1)

ch_g
ch_g

Reputation: 1440

First, your data is not correct hex - "GH" should not be there.

Once you get your data right,

Just pass hex as varchar -

Insert into temp values('0290')

It is same as -

Insert into temp values(hextoraw('0290'))

Upvotes: 0

Related Questions