0

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

2
Contributors
3
Replies
7
Views
10 Years
Discussion Span
Last Post by sandy_b76
1

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.