Error with while loop in pl sql

Question

I use while loop to calculate the integers from 1 to 10 in Pl Sql.

This is the code:

set serveroutput on;
declare
i number := 0;
sum number := 0;
begin
while i <= 10 loop
sum := sum + i ;
i := i + 1;
end loop;
dbms_output.put_line ( sum );
end;
/

what is the problem here?

This is the error message:

sum := sum + i ;
           *
ERROR at line 6: 
ORA-06550: line 6, column 12: 
PLS-00103: Encountered the symbol "+" when expecting one of the following: 
( 
ORA-06550: line 9, column 28: 
PLS-00103: Encountered the symbol ")" when expecting one of the following: 
(

Please add what is wrong, what you are expecting. Any error message? — Sam Segers
– Sam Segers, Commented Dec 25, 2015 at 13:38
oh this is the error message sum := sum + i ; * ERROR at line 6: ORA-06550: line 6, column 12: PLS-00103: Encountered the symbol "+" when expecting one of the following: ( ORA-06550: line 9, column 28: PLS-00103: Encountered the symbol ")" when expecting one of the following: ( — John Obey
– John Obey, Commented Dec 25, 2015 at 13:42

Ed Heal · Accepted Answer · 2015-12-25 13:43:39Z

5

Try not using the variable name sum.

i.e

set serveroutput on;
declare
i number := 0;
s number := 0;
begin
while i <= 10 loop
s := s + i ;
i := i + 1;
end loop;
dbms_output.put_line ( s );
end;
/

Seems to work

answered Dec 25, 2015 at 13:43

Ed Heal

60.3k18 gold badges91 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error with while loop in pl sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related