Oracle函数返回表

create or replace  TYPE oneDate as object(TM DATE) ;
create or replace TYPE TABLE_ONEDATE as TABLE OF ONEDATE ;

create or replace  FUNCTION fu_getdatetable
      (dtb DATE
      ,dte DATE
      ,splicnum INT
      ,splic VARCHAR2)
      RETURN table_onedate pipelined IS
         dt_dtt   DATE ;
         dt_dtb   DATE ;
         dt_dte   DATE ;
         i_splicnum   INT ;
         c_splic   VARCHAR2(10) ;
         r_daterow onedate ;
      BEGIN
         dt_dtb := dtb;
         dt_dte := dte ;
         r_daterow:= oneDate(sysdate);
         i_splicnum := splicnum;
         c_splic := splic;
         IF dt_dte IS NULL THEN
            SELECT SYSDATE INTO dt_dte FROM dual ;
         END IF ;

         IF dtb>dt_dte THEN
            dt_dtt := dt_dte ;
            dt_dte := dt_dtb ;
            dt_dtb := dt_dtt ;
         END IF ;