为什么就是不能执行啊
create or replace function funct(
maxnumber number,
minnumber number
)
return varchar2 isv_result varchar2(50);
v_count number(5);begin
select count(1) into v_count from abc;if v_count>maxnumber then
v_result:='the number is big';elsif v_count<minnumber then
v_result:='is small';else
v_result:='normal';end if;
return v_result;end funct;declare
maxnumber number:=1000;
minnumber number:=12;
d_result varchar2(50);
begin
d_result:=funct(maxnumber,minnumber);
dbms_output.put_line(d_result);end;
/
create or replace function funct(
maxnumber number,
minnumber number
)
return varchar2 isv_result varchar2(50);
v_count number(5);begin
select count(1) into v_count from abc;if v_count>maxnumber then
v_result:='the number is big';elsif v_count<minnumber then
v_result:='is small';else
v_result:='normal';end if;
return v_result;end funct;declare
maxnumber number:=1000;
minnumber number:=12;
d_result varchar2(50);
begin
d_result:=funct(maxnumber,minnumber);
dbms_output.put_line(d_result);end;
/
SQL> create or replace function funct(
2 maxnumber number,
3 minnumber number
4 )
5 return varchar2 is
6 v_result varchar2(50);
7 v_count number(5);
8
9 begin
10 select count(1) into v_count from emp;
11
12 if v_count>maxnumber then
13 v_result:='the number is big';
14
15 elsif v_count<minnumber then
16 v_result:='is small';
17
18 else
19 v_result:='normal';
20
21 end if;
22 return v_result;
23
24 end funct;
25 /函数已创建。SQL> declare
2 maxnumber number:=1000;
3 minnumber number:=12;
4 d_result varchar2(50);
5 begin
6 d_result:=funct(maxnumber,minnumber);
7 dbms_output.put_line(d_result);
8
9 end;
10 /
normalPL/SQL 过程已成功完成。
我这里提示错误:
警告,Although the function was created, there is a compile error