The application development team has developed PL/SQL procedures and functions for different
purposes and calls them as and when required. The loading of individual procedures or functions
into memory degrades performance with every call. Also, it causes a security problem for
individual subprograms and loss of program units when the whole system is transported into a
new location. Which method would you recommend to the application developers to solve this
problem?
A.
using anonymous PL/SQL blocks instead of subprograms
B.
referring to views instead of tables inside the subprograms
C.
creating PL/SQL packages to include interrelated subprograms
D.
avoiding the use of cursors in the subprograms