|
到底哪里出问题了
SQL> create or replace procedure pro5(ydno number) is
2 v_job emp.job% TYPE;
3 begin
4 select job into v_job from emp where empno= ydno;
5 if v_job='PRESIDENT' then
6 update emp set sal=sal+1000 where empno= ydno;
7 elseif v_job='MANEAGE' then
8 update set sal=sal+500 where empno= ydno;
9 else
10 update set sal=sal+200 where empno= ydno;
11 end if;
12 end;
13 /
警告: 创建的过程带有编译错误。 |
|