What are the benefits of subprograms?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to
ace your certification exam in first attempt.
Subprograms (stored procedures and functions) have the following benefits in addition to modularizing application development:
Easy maintenance: As subprograms are located in one location, it is easy to modify routines online without interfering with other users. Modifying one routine affects all the associated applications and eliminates duplicate testing, thereby eliminating the need to repeatedly perform the same maintenance task.
Improved data security and integrity: Subprograms provide improved data security by controlling direct access to database objects from non-privileged users possessing security privileges. As a subprogram is executed with its definer's right by default, it is easy to restrict the access privilege by granting the users a privilege that allows them to only execute the subprogram. Subprograms also provide data integrity by ensuring that related actions are performed together or not at all by funneling activity for related tables through a single path.
Enhanced performance: After a subprogram is compiled, the parsed code is available in the shared SQL area of the server, and the subsequent calls to the subprogram use this parsed code. This avoids the re-parsing for multiple users. This also avoids PL/SQL parsing at run time by parsing at compile time. Subprograms reduce the number of calls to the database and decrease network traffic by bundling SQL and PL/SQL commands.
Improved code clarity: Using appropriate identifier names to describe the action of the routines reduces the need for comments and enhances the clarity of the code.
Other articles
