Question

写了一个oracle函数，在命令窗口运行时 编译错误。求大神指点

create or replace function getNum(a in varchar2(1))
return number;
as
out_num number(3);
begin

if a = 'P' then
select count(*) into out_num from
pm_off_info t where t.p_flag='P';
dbms_output.put_line('P产品品的数量是：'||out_num);
else
select count(*) into out_num from
pm_off_info t where t.p_flag='S';
dbms_output.put_line('S产品的数量是：'||out_num);
end if;
return out_num;
end getNum;

Answer 1

create or replace function getNum(a in varchar2)
return number
is
begin
declare
out_num number(3);
begin

if a = 'P' then
select count(*) into out_num from
pm_off_info t where t.p_flag='P';
dbms_output.put_line('P产品品的数量是：'||out_num);
else
select count(*) into out_num from
pm_off_info t where t.p_flag='S';
dbms_output.put_line('S产品的数量是：'||out_num);
end if;
return out_num;
end ; end getNum;

追问

没有用啊，加了declare 和 end 还是编译错误
Warning: Function created with compilation errors