MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.19


create table audit (id int);

insert into audit values(1);
insert into audit values(2);
insert into audit values(3);
insert into audit values(4);
CREATE PROCEDURE CountMacro_Audit_Scaduti(
OUT CountMacro1 int,
OUT CountMacro2 int,
OUT CountMacro3 int,
OUT CountMacro4 int
)
BEGIN
   DECLARE CountMacro1_OUT INT DEFAULT 0;  
   DECLARE CountMacro2_OUT INT DEFAULT 0;
   DECLARE CountMacro3_OUT INT DEFAULT 0;  
   DECLARE CountMacro4_OUT INT DEFAULT 0;

select count(*)
INTO CountMacro1_OUT
from audit;

select count(*)
INTO CountMacro3_OUT
from audit;

select count(*)
INTO CountMacro4_OUT
from audit;

SET CountMacro1 = CountMacro1_OUT;
SET CountMacro2 = CountMacro2_OUT;
SET CountMacro3 = CountMacro3_OUT;
SET CountMacro4 = CountMacro4_OUT;


END 
call CountMacro_Audit_Scaduti(@CountMacro1,@CountMacro2,@CountMacro3,@CountMacro4);
select @CountMacro1,@CountMacro2,@CountMacro3,@CountMacro4


@CountMacro1
@CountMacro2
@CountMacro3
@CountMacro4


4
0
4
4