BLOB value null: empty locator [message #311815] |
Sun, 06 April 2008 23:56  |
me_arindam
Messages: 26 Registered: March 2008 Location: India
|
Junior Member |
|
|
Hi,
I have a table called image
in this table two columns are there:
1. image_id
2. image
image column is og BLOB type.
Please let me know is it mandatory to set empty locator to the image column beforupdating it to a not null value from null value?
Means,
initially i want to insert a null value to that column.
Can I do that like,
insert into image values ( 1,null);
an then update like
update image
set image = 'A'
where image_id = 1;
Or initially I need to set empty_blob() to image column like:
insert into image values ( 1,empty_blob());
and then update that column.
Without the empty locator can't I set the value null?
Thanks,
Arindam
|
|
|
|