SQL & PL/SQL

Hi,

I am trying to identify reocrds where i have chr(49824) value. Worked when tried in sql but failed when tried within procedure in plsql?

Works in sql

select *
       from temp
        where instr(name,chr(49824) )>0

--when trying in small procedure written in plsql, it does not work, please anyone can guide how can i achieve this task in plsql

  if instr(V_name,chr(49824)) >0 then

                v_name:=replace(v_name, chr('49824'),'') ;
                 dbms_output.put_line('after removing chr(49824)'||v_name);


            end if;

Best Regards,