--主要是那个输出参数为布尔型 变量,怎么在SQL Plus中定义啊?
create or replace
procedure UPDATE_EMP(p_empno number, p_decrease number,
p_success out boolean)
is
begin
if p_decrease = 0 then
p_success := false;
else
update EMP
set SAL = SAL / p_decrease
where empno = p_empno;
p_success := true;
end if;
end;
/---------------------------------------望高人指点一、二! 谢谢......
create or replace
procedure UPDATE_EMP(p_empno number, p_decrease number,
p_success out boolean)
is
begin
if p_decrease = 0 then
p_success := false;
else
update EMP
set SAL = SAL / p_decrease
where empno = p_empno;
p_success := true;
end if;
end;
/---------------------------------------望高人指点一、二! 谢谢......
p_success boolean;
begin
UPDATE_EMP(1,2,p_success);
end;
/
p_success boolean;
begin
UPDATE_EMP(1,2,p_success);
end;
/
p_success boolean;
begin
UPDATE_EMP(1,2,p_success);
end;