I want to manually insert an ASCII stream into a column of type BLOB in oracle
- by Scott Turley
Is there a command that will convert ASCII into blob?
I have the following table:
sample_table:
-------------
id : NUMBER
type : NUMBER
version : NUMBER
data : BLOB
When doing the following command:
insert into sample_table values (1, 0, 1, '');
I'm getting the following error: ORA-01465: invalid hex number.