创建的函数无法使用

[为了未来]

create or replace function dmpp(dm in varchar2(20), dmnr in varchar2(50)) return varchar2(20) is
exchange_dm varchar2(20);
begin
if dm = '职业代码' then
begin
select code into exchange_dm from N041-Dictionary
where category ='职业代码' and name=dmnr;
exchange_dm: = decode(exchange_dm,null,'90',@exchange_d);
end
elseif dm = '入院病情代码' then
exchange_dm := (case when substr(@dmnr,1,1) ='1' then '1'
when substr(@dmnr,1,1) ='2' then '2'
when substr(@dmnr,1,1) ='3' then '3'
else '4'
end) ;


else
exchange_dm :='';
end if;
RETURN exchange_dm;
end dmpp;



函数创建好后提示pls-00103

[为了未来]

[卖水果的net]

create or replace function dmpp(dm in varchar2(20), dmnr in varchar2(50)) return varchar2(20) is


存储过程或函数，参数只能写类型，不能写长度

create or replace function dmpp(dm in varchar2, dmnr in varchar2) return varchar2 is