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.
I solved this problem with following.
SELECT nvl(length(BLOB_Field),0) INTO variable
IF variable > 0 THEN
strMessage := 'BLOB Field has data';
strMessage := 'BLOB Field is empty';
Hope This will help others.
try using the predefined package dbms_lob to get some info regarding that.
Thanks a lot.