function

create or replace function fun_check_ftmobile
(
      pTMobile    varchar2
)
/* ===========================================
      Users: Qiang.cai
      Timer: 2009-12-14 23:03:00
      Functio: 验证子卡是否存在 Y已存在 N不存在
=========================================== */
return varchar2 is
      pCount  int         := 0;
      pResult varchar2(2) := '';
begin
      select count(*) into pCount from x_terminal where ftmobile = pTMobile;
      if pCount > 0 then
         pResult := 'Y';
      else
         pResult := 'N';
      end if;
      return(pResult);
exception
      when others then
      raise_application_error(sqlcode,'fun_check_ftmobile;info:'||sqlerrm||';pTMobile='||pTMobile);
end fun_check_ftmobile;