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;
上一篇: common
下一篇: MySql_connection
推荐阅读
-
php运行出现Call to undefined function curl_init()的解决方法
-
php通过function_exists检测函数是否存在的方法
-
IIS下PHP连接数据库提示mysql undefined function mysql_connect()
-
详解Vue.js搭建路由报错 router.map is not a function
-
【浅析C++11】std::function和std::bind
-
function类型解析
-
Fatal error: Call to undefined function curl_init()解决方法
-
Function eregi is deprecated (解决方法)
-
Function,Object.creat();
-
Arguments Optional 计算两个参数之和的 function