How To Check the ASCII Characters in a Name

This script allows an ID to be entered and it will display the related ASCII characters.  Used to check for bad names.

set serveroutput on

declare

   v_id varchar2(9) := '1329455';

   v_name varchar2(200);

   v_i number(4);

begin

   select spriden_last_name||' '||spriden_first_name||' '||spriden_mi

   into   v_name

   from   spriden

   where  spriden_id = v_id

   and    spriden_change_ind is null;

   for v_i in 1..length(v_name) loop

      dbms_output.put_line(v_i||' '||substr(v_name,v_i,1)||' '||ascii(substr(v_name,v_i,1)));

   end loop;

end;

/