Always complicate that

[dr_gori]

Here goes the code to commit 500 in 500 lines:

Select all

 
LOOP 
  .. códigos .. 
  .. códigos .. 
 
  IF MOD(j, 500) = 0 
  THEN 
       COMMIT; 
  END IF; 
 
  j := j + 1; 
 
END LOOP;

Would not it be faster to put only one if without the mod function?

Select all

IF j = 500  
THEN 
  j:=0;  
  COMMIT; 
END IF;

In place of

Select all

IF MOD(j, 500) = 0  
THEN  
  COMMIT 
END IF;

So you do not need to use the mod 500 times function.
: -O

[victorhugomuniz]

really ..

.. is a pearl

rsrsrs

[diegolenhardt]

What a beauty, AUIHAUIHIAU

[RodrigoValentim]

This is very normal! I'vê seen this several times ...

[Maverick]

Although delayed in the comment, it makes sense.

If for some reason the counter J can not be zeroed, it can not commit when J is equal to 500.

The Commit will occur every 500 records , multiples of 500

Select all

MOD(2000,500) = 0

On the other hand, it could have declared an auxiliary accountant.

[diegolenhardt]

only to do as Dr_Gori said a if = 500

and at the end of the entire procedure another if

Select all

if j > 0 then 
  commit;

to commit what was lacking ...