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;

 

posted @ 2013-01-23 16:14  水手哥  阅读(587)  评论(1编辑  收藏  举报