create or replace procedure sp_calcsum1(n number)
as
n number;
result1 number;
begin
n:=0;result1:=0;
while n<=100 loop
result1:= result1+n;
n:=n+1;
end loop;
DBMS_OUTPUT.PUT_LINE('结果是'||result1);
end;
/
as
n number;
result1 number;
begin
n:=0;result1:=0;
while n<=100 loop
result1:= result1+n;
n:=n+1;
end loop;
DBMS_OUTPUT.PUT_LINE('结果是'||result1);
end;
/
as
n number;这两个名字重复了,你改掉一个就可以了。