I moved this thread to the Oracle Database Administration, since it does not belong under how-to. Check to see if the c1.text column is null for any of the rows.