CREATE OR REPLACE PROCEDURE DELETE_TMPDUPLICACOTACAO IS
BEGIN
    LOOP
    	DELETE FROM TMP_DUPLICACOTACAO
       	 WHERE ROWNUM < 10;
      
      	EXIT WHEN SQL%ROWCOUNT = 0;
      	COMMIT;
    END LOOP;
END DELETE_TMPDUPLICACOTACAO;
/