CREATE OR REPLACE FUNCTION fn_ipaddr_to_province (p_ipaddr NUMBER) RETURN VARCHAR2IS v_ret VARCHAR2 (100) := '';BEGIN BEGIN SELECT province INTO v_ret FROM ipdb WHERE start_ip <= p_ipaddr AND end_ip >= p_ipaddr AND ROWNUM = 1; EXCEPTION WHEN NO_DATA_FOUND THEN v_ret := ''; END; RETURN v_ret;EXCEPTION WHEN OTHERS THEN RAISE;END fn_ipaddr_to_province;/...BEGIN SELECT serverip INTO v_serverip FROM domainname WHERE province = fn_ipaddr_to_province (p_ip) AND ROWNUM = 1;EXCEPTION WHEN NO_DATA_FOUND THEN v_serverip := 'mp3.u-vv.com';END;......v_province := fn_ipaddr_to_province (p_ip);BEGIN SELECT serverip INTO v_serverip FROM domainname WHERE province = v_province AND ROWNUM = 1;EXCEPTION WHEN NO_DATA_FOUND THEN v_serverip := 'default domain';END;...
【责编:Peng】
相关文章编辑推荐
相关产品和培训
文章评论
认证培训 专题推荐
今日更新 社区讨论 博客论点 频道精选
您现在的位置： 
佚名
2007-6-22
