测试生成站址:::
--测试生成空间数据
declare v_result varchar2(64);
--丰台妇幼保健院
v_ishave number default 0;
v_xzq varchar2(32); --行政区
v_LONGITUDE number default 0;
v_latitude number default 0;
v_siteid number;
v_xzqcode varchar2(64);
begin
--先判断这个id站址是否存在
select count(*) into v_ishave from jzsh_site_location s where s.fldid=99999999210266540;
if v_ishave>0 then
--声明经纬度
SELECT j.latitude,j.longitude into v_latitude,v_LONGITUDE FROM jzsh.jzsh_site_location j where j.fldid= '99999999210266540' and rownum=1;
-- select s.longitude into v_LONGITUDE ,s.latitude into v_latitude from jzsh.jzsh_site_location s where s.fldid=vFldId and rownum=1;;
end if;
sde.createsitebyid('99999999210266540',v_result);
end;