select XB into Result from T_XB where p_CODE = CODE 应该是 select XB into Result from T_XB where CODE=p_CODE
定义部分出了错,语句部分也出了错. CREATE OR REPLACE function CONVERT_XB_TO_CHAR ( p_CODE in number) return varchar2 is Result varchar2(50); begin select XB into Result from T_XB where CODE=p_CODE;--此处一定要单记录 if Result is null then return ('未知');
else return(Result); end if; exception when others then return ('未知');
我是在visal studio里面编辑这个函数,如果函数有错误,
就不能够保存。
from T_XB
where p_CODE = CODE
应该是
select XB into Result
from T_XB
where CODE=p_CODE
CREATE OR REPLACE function CONVERT_XB_TO_CHAR
( p_CODE in number) return varchar2 is
Result varchar2(50);
begin select XB into Result from T_XB where CODE=p_CODE;--此处一定要单记录 if Result is null then
return ('未知');
else
return(Result);
end if;
exception
when others then
return ('未知');
end CONVERT_XB_TO_CHAR;