Advertisement
Guest User

Untitled

a guest
Jun 20th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.21 KB | None | 0 0
  1. MEMBER PROCEDURE retirar_estoque IS
  2. i INTEGER;
  3. item ITEMCOMPRA_TP;
  4. BEGIN
  5. FOR i IN 1..SELF.ITENS.COUNT
  6. LOOP
  7. UPDATE ITEMESTOQUE
  8. SET QUANTIDADE = QUANTIDADE -1
  9. WHERE CODIGO = SELF.ITENS(i).ITEMESTOQUE.CODIGO;
  10. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement