problems selecting clob field

Hi,

I have the following query

select * from orders where order_message = null

The order_message is a clob field and stores the order as xml. Oracle does not allow me to do this query on a clob field

any ideas how I can do a select on clob field ?

John Received on Mon Jan 29 2007 - 11:24:22 CST