SQL & PL/SQL

Hi

I'm selecting a long field and need to do 'LIKE' in the where I'm getting and inconsistent datatypes error, I need conversion function from SQL not PL/SQL

select v.view_name,v.text
from user_views v
WHERE v.text LIKE '%XYZ%';

please advice