29
Underlying Types and Functions
type lov_oty is object (id, display_tx);
type lov_nt is table of lov_oty;
function f_getLov_nt
(i_table_tx,i_id_tx,i_display_tx,i_order_tx)
return lov_nt is
v_out_nt lov_nt := lov_nt();
begin
execute immediate
'select lov_oty('
u
|i_id_tx||','||i_display_tx||')'||
' from
'||i_table_tx||
' order by
'||i_order_tx
bulk collect into v_out_nt;
return v_out_nt;
end;