CREATE OR REPLACE FUNCTION fun_get_site_add (v_site_id number)
return varchar2
as
v_kind number;
v_add varchar2 (255);
var_return varchar2(255);
cursor cur_coordinate is
select b.LINK_ADD,b.ROOM_KIND_CODE from ip_room b where b.site_id=v_site_id;
begin
open cur_coordinate;
var_return:=' ';
loop
fetch cur_coordinate into v_add,v_kind;
exit when cur_coordinate %notfound;
if v_kind = 1 then
return v_add;
end if;
if v_kind <>1 then
var_return:= v_add;
end if;
end loop;
close cur_coordinate;
return var_return;
end;
/
return varchar2
as
v_kind number;
v_add varchar2 (255);
var_return varchar2(255);
cursor cur_coordinate is
select b.LINK_ADD,b.ROOM_KIND_CODE from ip_room b where b.site_id=v_site_id;
begin
open cur_coordinate;
var_return:=' ';
loop
fetch cur_coordinate into v_add,v_kind;
exit when cur_coordinate %notfound;
if v_kind = 1 then
return v_add;
end if;
if v_kind <>1 then
var_return:= v_add;
end if;
end loop;
close cur_coordinate;
return var_return;
end;
/