CREATE OR REPLACE procedure MY.my_temp
is
begin
  for r_list in (
    select first, last, data, city, socnum, count(*) from person
    where 1=1
    and socnum= '112233445566'
    group by first, last, data, city, socnum having count(*) > 1
--select '' first, '' last, '' data, '' city, '' socnum from dual
    loop
		dbms_output.put_line('test: ' || r_list.socnum);
    end loop;
end;

 "select '' first, '' last, '' data, '' city, '' socnum from dual"