Procedures or function using set command

[Phil Siyam]

Hi,
We recently upgraded from 8.0.24 to 8.0.26. Any procedures or function using set command are very slow and we have been changing set to into. E.g

-- Old Query
set var_1 = (select col1 from tab1 where col2 = 11);

-- New Query
select col1 into var_1 from tab1 where col2 = 11;


Is there better way to do it?

Thanks in advance.