37 of 62
Nested Tables - Example 2b
uWrite a PL/SQL function to hide all required logic
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('
||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;