Hi Friends, Thanks for your suggestions and observations, My requirement is to pass the date parameters into that function , based on that dates i would like to retrieve the data from DB and present in my report. For that i have defined two global variables in my PLSQL package P_FROM_DATE and P_TO_DATE, and also the same…

Thank you very much. This is working for my requirement I have created a separate procedure in my package with global variables p_from_date date, p_to_date date procedure getdates(p_from_date date, p_to_date date) as begin execute immediate 'truncate table date_range'; insert into date_range values (p_from_date,…