注册 登录
编程论坛 Oracle论坛

报ORA-06575 程序包或函数GETVALUEOFLX处于无效状态!求帮助

do8do8do8 发布于 2017-11-17 12:21, 6337 次点击
create or replace function GetValueOfLx (GV_constslsid in INTEGER,GV_constvalue in NVARCHAR2(100))
return NVARCHAR2(100)
is
GV_return NVARCHAR2(100);
begin
   GV_return ='';
   select GV_return:=consttrans from bdcs_constcls where
   constslsid=GV_constslsid and constvalue=GV_constvalue;

return GV_return;
end;
yqzd
执行select GetValueOfLx(8,'3') from sh 报错
0 回复
1