But this doesn't seem to work at first glance. I will dig deeper!!
In the meanwhile let me share my views.
LIKE v_namesearch || '%';
seems to be the problem. May be because v_namesearch is a string variable, it also needs a single quotes. But how??