Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER trg_desativar AFTER INSERT OR UPDATE ON pagamento_banco FOR EACH ROW WHEN (NEW.estado_pagamento = '2')
- DECLARE
- num_dispositivo NUMBER;
- BEGIN
- SELECT
- num_serie
- INTO
- num_dispositivo
- FROM
- (
- SELECT d.num_serie FROM pagamento pag, veiculo v, dispositivo d
- WHERE
- pag.id = :NEW.id
- AND pag.matricula = v.matricula
- AND d.matricula = v.matricula
- ORDER BY d.num_serie DESC
- ) WHERE ROWNUM = 1;
- IF num_dispositivo IS NOT NULL THEN
- UPDATE dispositivo SET estado = 0 WHERE num_serie = num_dispositivo;
- END IF;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement