oracle带参数视图使用

create or replace package p_view_param  is 
   
   function set_sdate(sdate date) return date;
   function get_sdate return date;
   
   function set_edate(edate date) return date;
   function get_edate return date;

end p_view_param;

create or replace package body p_view_param is 
       
    paramSdate date; 
    paramEdate date; 

    function set_sdate(sdate date) return date is 
    begin 
        paramSdate:=sdate;
    return sdate;
    end;         

    function get_sdate return date is 
    begin 
        return paramSdate;
    end; 

    function set_edate(edate date) return date is
    begin 
        paramEdate:=edate;
        return edate; 
    end;        

    function get_Edate return date is 
    begin 
        return paramEdate; 
    end;

end p_view_param;

CREATE OR REPLACE FORCE VIEW "HZQGAS"."VM_REPORT_NO_USER_SALE_SORT" ("ysl", "yse", "customer_Code", "rel_Chg_Account_No", "gas_Type_Id", "area_Id") AS 
select nvl(sum(gas),0) ysl,nvl(sum(sse),0.00)yse,customer_Code,rel_Chg_Account_No,gas_Type_Id,area_Id 
      from gas_Report_Ysl 
      where customer_Kind='9' and rel_Chg_Account_No is not null             
          and trade_date>=p_view_param.get_sdate()
          and trade_date<p_view_param.get_edate()
      group by customer_Code,gas_Type_Id,area_Id,rel_Chg_Account_No

select * from VM_REPORT_NO_USER_SALE_SORT where p_view_param.set_sdate(to_date('2017-09-01','yyyy-MM-dd'))=to_date('2017-10-01','yyyy-MM-dd')