PLS-00364
loop index variable 'string' use is invalid
Cause
A reference to a loop counter was found in an inappropriate context. For example, the following statement is illegal because the loop counter is used as the terminal value in its own range expression: FOR j IN 1 .. j LOOP ... -- illegal
An attempt was made to assign the value of an OUT parameter to bonus := bonus * 2; -- illegal SELECT sal + bonus INTO wages FROM emp ... -- illegal ... END IF; ...
Action
Change the loop range expression so that it does not reference the loop counter. If you want to refer in the range expression to another variable with the same name as the loop counter, change either name or qualify the variable name with a label.
Use an IN OUT parameter instead of the OUT parameter. Inside a
PLS-00364
loop index variable 'string' use is invalid
Cause
A reference to a loop counter was found in an inappropriate context. For example, the following statement is illegal because the loop counter is used as the terminal value in its own range expression: FOR j IN 1 .. j LOOP ... -- illegal
An attempt was made to assign the value of an OUT parameter to bonus := bonus * 2; -- illegal SELECT sal + bonus INTO wages FROM emp ... -- illegal ... END IF; ...
Action
Change the loop range expression so that it does not reference the loop counter. If you want to refer in the range expression to another variable with the same name as the loop counter, change either name or qualify the variable name with a label.
Use an IN OUT parameter instead of the OUT parameter. Inside a
PLS-00364
loop index variable 'string' use is invalid
Cause
A reference to a loop counter was found in an inappropriate context. For example, the following statement is illegal because the loop counter is used as the terminal value in its own range expression: FOR j IN 1 .. j LOOP ... -- illegal
An attempt was made to assign the value of an OUT parameter to bonus := bonus * 2; -- illegal SELECT sal + bonus INTO wages FROM emp ... -- illegal ... END IF; ...
Action
Change the loop range expression so that it does not reference the loop counter. If you want to refer in the range expression to another variable with the same name as the loop counter, change either name or qualify the variable name with a label.
Use an IN OUT parameter instead of the OUT parameter. Inside a