ORA-00997 on select

SQL> select body from proc where body='NULL1';

select proc_body from proc where body='NULL1'

                                 *

ERROR at line 1:

ORA-00997: illegal use of LONG datatype

But:

SQL> select body from proc where body is not null;

BODY

--------------------------------------------------------------------------------

NULL0

NULL1

NULL2

NULL3

How can I get around this problem? I need to locate the row which matches the column='NULL1' for a

subsequent UPDATE of that column.

The column datatype is LONG

--

Christoph