Migrating from Firebird to MySQL

2

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^
    
asked by anonymous 09.01.2018 / 14:16

0 answers