Untitled

DECLARE
BEGIN
  FOR pagos IN
  (SELECT    *
  FROM mercadopago.payment_credit_card o
  WHERE ##CRITERIO DE BUSQUEDA##
  )
  LOOP
    BEGIN
      UPDATE mercadopago.payment_credit_card
      SET status           ='D',
        last_modified_date = SYSDATE,
        last_modified_by   = 40173263,
        prg_id             = 'MANUAL'
      WHERE move_id        = pagos.payment_id;
      COMMIT;
    END LOOP;
    COMMIT;
  END;