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;
上一篇: 类的反射
下一篇: eclipse相关技巧总结
推荐阅读
-
php运行出现Call to undefined function curl_init()的解决方法
-
SQl Function 创建函数实例介绍
-
PHP错误WARNING: SESSION_START() [FUNCTION.SESSION-START]解决方法
-
Error in created hook: “TypeError: Object(...) is not a function“
-
ES6标准 Arrow Function(箭头函数=>)
-
TypeError: 'function' object is not subscriptable
-
Fatal error: Call to undefined function: iconv() in d:wwwPiaokouwwwrootpiaok解决方案
-
javascript下function声明一些小结_javascript技巧
-
解决Fatal error: Maximum function nesting level of ’100′ reached报错
-
PHP在foreach中引入function的效率如何?