ORA-00932: inconsistent datatypes: expected - got CLOB

On Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.13.0.0.0, using sqlplus on the db server itself.

I use some sql to update email addresses: 

update temail_addr set email_addr = 'test@somedomain.com' 

where email_addr not like '%http%'

where the column email_addr is is CLOB. This sql statement works correctly. 

I need to exclude some email addresses from the update statement and have tried using "not in" and sub-select: 

update temail_addr set email_addr = 'test@somedomain.com' 

where email_addr not like '%http%'

and email_addr not in (select email_address from tuser where user_nm in ('list of names');