oralce function

create or replace function f_getPro(type_id_value in number, activity_id_value in number) return varchar2 is
  Result varchar2(10000);
begin
  declare cursor c_cur is
  select provice from t_bjoa_market_province where type_id = type_id_value and activity_id = activity_id_value;
  begin
    for v_result in c_cur loop
      Result := Result||v_result.provice||',';
    end loop;
  end;
  return(Result);
end f_getPro;