The Weird and The Wonderful

CREATE PROCEDURE p_create_po_serial (
          IN param_reception_ids VARCHAR(255),
          IN param_serial_nos VARCHAR(1023),
          OUT serial_no_ids VARCHAR(1023))
BEGIN  
  /*Current reception id to parse*/
  DECLARE id_to_parse VARCHAR(255);
  /*Left reception ids to parse*/
  DECLARE temp_reception_ids VARCHAR(255);
  /*Counter to count something, I'll figure out later what I need it for*/
  DECLARE c*** INT;
  SET temp_reception_ids = param_reception_ids;
  SET serial_no_ids = '';
  SET c*** = 0;
  
  WHILE (length(temp_reception_ids) > 0) DO
    SET id_to_parse = SUBSTRING_INDEX(temp_reception_ids, ';', 1);
    SET serial_no_ids = concat(serial_no_ids, '-', id_to_parse);
    
    <Some 200 more lines, in which 'c***' makes absolutely no appearance whatsoever>

    SET temp_reception_ids = SUBSTRING(temp_reception_ids, length(id_to_parse) + 2, length(temp_reception_ids));
    SELECT id_to_parse, temp_reception_ids;
    SET c*** = c*** + 1;
  END WHILE;
  
END;

try
{
    return true;
}
catch (Exception)
{
    return false;
}

List<char> _chars = new List<char>();
 
for (int i = 0; i < 2000; i++)
 {
 if ((i >= 48 && i <= 57) || (i >= 97 && i <= 122))
 {
 _chars.Add((char)i);
 }
 }

string _chars = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";