Created
December 29, 2022 12:51
-
-
Save juanchehin/4bc7e08e9fa8870fcbf0ea7e98338f67 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SALIR:BEGIN | |
/* | |
Permite .... | |
*/ | |
DECLARE pPrecioCompra decimal; | |
DECLARE pStock,pIdSucursal int; | |
-- Manejo de error en la transacción | |
DECLARE EXIT HANDLER FOR SQLEXCEPTION | |
BEGIN | |
SHOW ERRORS; | |
-- SELECT 'Error en la transacción. Contáctese con el administrador.' Mensaje; | |
ROLLBACK; | |
END; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment