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