A reader, June 29, 2016 - 6:09 am UTC
Thank you very much for the suggestion. We just removed the below
execute statement
and we compared directly l_high_value with p_seq that reduced further time.
l_high_value := i.high_value;
13 execute immediate 'select '||l_high_value||' from dual' into l_date;
14 if l_date = p_seq then
June 29, 2016 - 7:00 am UTC
That is risky, because you dont control the format of "high_value" in the dictionary. All you know is that it is an expression that evaluates to a date (or some other value depending on the range).