oracle pl/sql 通过存储过程返回数据表

oracle存储过程返回表:

  --游标返回数据集测试
  procedure RETURN_CURSOR(p_TenantID     in number,
                          p_TravelMainID in number,
                          p_cursor       out DetCusor) is
  begin
    open p_cursor for
      select *
        from tm_traveldetail
       where traveldetailid = p_TravelMainID
         and traexpensesitemid = p_TenantID;
  end;