How to check if BLOB field is NULL or Not in a Table ?

[sandy_b76]

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

[sandy_b76]

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

[debasisdas]

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

[sandy_b76]

Thanks a lot.