I am migrating a project in Firebird to MySQL, I have a difficulty in converting a procedure, I would like any tip in how to proceed, below the procedure in FIREBIRD.
CREATE PROCEDURE EXECUTA_INATIVA_TABELAS (
OPERADOR VARCHAR(20),
ALTERACAO TIMESTAMP)
AS
DECLARE CGC VARCHAR(18);
DECLARE VIGENCIA TIMESTAMP;
BEGIN
FOR
SELECT CGC, VIG_TAB
FROM PARM_CALCULO
WHERE ( VIG_TAB IS NOT NULL )
INTO :CGC, :VIGENCIA
DO
BEGIN
EXECUTE PROCEDURE INATIVA_TABELAS(:CGC, :VIGENCIA, :OPERADOR,
:ALTERACAO);
END
SUSPEND;
END^