what this problem? table(cast(array))
exits in databse one type
" type InNumberTab is table of number;"
declare
v_tbseq_trans:= InNumberTab(null);
select count(*) into v_cont
from dados_propriedade dp
where dp.num_pessoa=p_num_pessoa
group by num_nirf;
v_tbseq_trans.EXTEND(SQL%ROWCOUNT);
v_cont:=0;
for v_cs in
(select to_number(replace(dp.num_nirf,'-','')) nirf, max(dp.seq_transacao) seq_transacao
from dados_propriedade dp
where dp.num_pessoa=p_num_pessoa
group by dp.num_nirf) loop
v_tbseq_trans(v_cont):=v_cs.seq_transacao;
v_cont:=v_cont+1;
END LOOP;
open p_cursor_prop for
select
*
from dados_propriedade dp
where dp.seq_transacao in (SELECT column_value FROM TABLE(CAST(v_tbseq_trans as InNumberTab)));