Advanced Datatype Example 2c
uVIEWS on top of dynamic functions:
ØCompletely hide the underlying logic from the UI
ØINSTEAD-OF triggers make logic bi-directional
ØMinor problem – there is still no way of passing
parameters into the view other
than some kind of globals
Create or replace view v_generic_lov as
select id_nr, display_tx
from table( cast(f_getLov_nt
(GV_pkg.f_getCurTable,
GV_pkg.f_getPK(GV_pkg.f_getCurTable),
GV_pkg.f_getDSP(GV_pkg.f_getCurTable),
GV_pkg.f_getSORT(GV_pkg.f_getCurTable))
as lov_nt)
)