CURSOR WITH PARAMETER

[mber]

Try:

LIKE ''''|| '%'||v_namesearch||'%'||'''' OR
LIKE '''%'||v_namesearch||'%''';

Basically, '' represents " ' " .