APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Testing Clob Field for Null?

Pete88Aug 20 2009 — edited Aug 21 2009

Hello

I am trying the test the clob field for null or space without success

I have tried the following

Declare
Data1 Clob;
Begin

if data1 is not null then -- this does not work

if data1 = null --this does not work

if data1 = '' then -- this does not work

What is wrong with my syntax or in my thinking?

All ideas welcome

Thanks

Pete

This post has been answered by BarryG on Aug 20 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2009

Added on Aug 20 2009

#apex-discussions

8 comments

12,794 views