LOOP
Remarks
A
LOOP
statement repeats the execution of a block of statements.
This statement is only allowed in stored procedures and triggers.
Pervasive PSQL does not support post-conditional loops (
REPEAT...UNTIL
).
Examples
The following example increments the variable vInteger by 1 until it reaches a value of 11, when the loop is ended.
TestLoop:
LOOP
IF (:vInteger > 10) THEN
LEAVE TestLoop;
END IF;
SET :vInteger = :vInteger + 1;
END LOOP;
See Also
CREATE PROCEDURE
CREATE TRIGGER
IF