CREATE OR REPLACE TRIGGER saldo_financeiro
	AFTER UPDATE OF valorPat
		ON patrocinio
			FOR EACH ROW
				BEGIN
					UPDATE patrocinio SET saldoPat = saldoPat + ( :new.valorPat - :old.valorPat ) WHERE numEd = :new.numEd AND codEv = :new.codEv;
					UPDATE edicao SET saldoFinanceiroEd = saldoFinanceiroEd + ( :new.valorPat - :old.valorPat ) WHERE numEd = :new.numEd AND codEv = :new.codEv;
				END;