============================
if lv=1 then
select id1 into ret from TB_DISTRICT_SERACH where id=var_rigionid;
RETURN(ret);
end if
if lv=2 then
select id2 into ret from TB_DISTRICT_SERACH where id=var_rigionid;
RETURN(ret);
end if
=============================
end if 后加分号;
代码块用begin...end;============================= if lv=1 then
begin
select id1 into ret from TB_DISTRICT_SERACH where id=var_rigionid;
RETURN(ret);
end;
end if;
if lv=2 then
begin
select id2 into ret from TB_DISTRICT_SERACH where id=var_rigionid;
RETURN(ret);
end;
end if;
=============================
if lv=1 then
select id1 into ret from TB_DISTRICT_SERACH where id=var_rigionid;
RETURN(ret);
end if
if lv=2 then
select id2 into ret from TB_DISTRICT_SERACH where id=var_rigionid;
RETURN(ret);
end if
=============================
end if 后加分号;
代码块用begin...end;============================= if lv=1 then
begin
select id1 into ret from TB_DISTRICT_SERACH where id=var_rigionid;
RETURN(ret);
end;
end if;
if lv=2 then
begin
select id2 into ret from TB_DISTRICT_SERACH where id=var_rigionid;
RETURN(ret);
end;
end if;
=============================
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货