Null Clob or Isn't it?

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Thu, 7 Sep 2006 03:24:00 -0700 (PDT)
Message-ID: <20060907102400.70657.qmail@web34114.mail.mud.yahoo.com>

Hi All,

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 9.2.0.6

Thanks
Charlotte

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 07 2006 - 05:24:00 CDT