I want to manually insert an ASCII stream into a column of type BLOB in oracle
Posted
by Scott Turley
on Stack Overflow
See other posts from Stack Overflow
or by Scott Turley
Published on 2010-05-28T17:23:29Z
Indexed on
2010/05/29
6:22 UTC
Read the original article
Hit count: 195
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.
© Stack Overflow or respective owner
