How to insert some DUMMY value to BLOB field
Posted: Tue Jun 07, 2016 10:45 pm
Hi All,
Lets consider table A has 5 columns and i need to insert a row here.
For COL1 - 4, we have the data
and for col - 5 which is a BLOB field and is declared as NOT NULL, we dont have any data from input sources. Our requirement is to insert some dummy values into this BLOB field for now. I have tried many ways to insert dummy fields into this field .. and all in vain.
BLOB(X'123')
cast(x'000001' as blob) and so many...
INSERT INTO DATA_BLOB_DUMMY
(
COL1, COL2, COL3, COL4
, BLOB_FIELD
)
VALUES
(
:COL1
, :COL2
, :COL3
, :COL4
,BLOB('000001')
Please help me how to get an entry in this table with some value for BLOB?
Lets consider table A has 5 columns and i need to insert a row here.
For COL1 - 4, we have the data
and for col - 5 which is a BLOB field and is declared as NOT NULL, we dont have any data from input sources. Our requirement is to insert some dummy values into this BLOB field for now. I have tried many ways to insert dummy fields into this field .. and all in vain.
BLOB(X'123')
cast(x'000001' as blob) and so many...
INSERT INTO DATA_BLOB_DUMMY
(
COL1, COL2, COL3, COL4
, BLOB_FIELD
)
VALUES
(
:COL1
, :COL2
, :COL3
, :COL4
,BLOB('000001')
Please help me how to get an entry in this table with some value for BLOB?