Home » SQL & PL/SQL » SQL & PL/SQL » BLOB value null: empty locator (Oracle 9i/1og)
BLOB value null: empty locator [message #311815] Sun, 06 April 2008 23:56 Go to next message
Messages: 26
Registered: March 2008
Location: India
Junior Member

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?

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?

Re: BLOB value null: empty locator [message #311828 is a reply to message #311815] Mon, 07 April 2008 00:54 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT an expert question. Why did you post this in expert forum and not in newbie one?

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them including what is said about formatting.

As you are an expert, I don't answer the question because you obviously already knows it.

Previous Topic: Problem with PIPES
Next Topic: How to see/check the null records for this update statement; getting ORA-01407 error ?
Goto Forum:

Current Time: Tue Oct 25 23:21:11 CDT 2016

Total time taken to generate the page: 0.08707 seconds