ref cursor怎么得到返回的记录总数???
包头:
create or replace package pkg_select
as
type c_1 is ref cursor;
end;
过程:
create or replace procedure sp_select
(
refCur out pkg_select.c_1,
num_select_cnt out number
)
as
begin
open refCur for
select * from 表名 ;
num_select_cnt := refCur%rowcount ;=>怎样得到记录总数?此处的结果是0
end;
请大家帮忙!!!