I expect that it has been initialised with empty_clob(); which (from memory) creates the clob pointer but no content. The content length would be zero, the column would be non null.
on the other hand all this is from memory, to save me going mad during an ebusiness suite clone, and so could be utter rubbish.
I'm new to working with CLOBs. Any ideas on what I'm missing here?
My query below returns a non-zero result:
SELECT count(*) FROM my_table WHERE clob_column IS NOT NULL AND LENGTH(clob_column) = 0;
How can I have a CLOB column of length zero which is not null?
This is on 184.108.40.206
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l
-- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l