Hi,

How to check if BLOB field is NULL or Not in a Table though other data is available in a selected row ? I need to do this in a sql statement.

Thanks
Sandy

Recommended Answers

try using the predefined package dbms_lob to get some info regarding that.

Jump to Post

All 3 Replies

I solved this problem with following.

SELECT nvl(length(BLOB_Field),0) INTO variable
FROM <<Table_Name>>
WHERE <<Condition>>

IF variable > 0 THEN
strMessage := 'BLOB Field has data';
ELSE
strMessage := 'BLOB Field is empty';
END IF;


Hope This will help others.


Thanks
Sandy

try using the predefined package dbms_lob to get some info regarding that.

Thanks a lot.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.