I have below SQL that I wasnt to run from a solaris machine using sqlplus
select * from TABLE_NAME where regexp_like(field_value, '|||||||||||||||||||||||||||||||||||||||||||||||');
When I cat the file UTF char shows perfect however when i run the script from sqlplus it returns nothing. If you run it from sqldevloper it actually has these UTF char which should return rows.
Can someone help on what do I need to in order to get it working from sqlplus?