Named PL/SQL blocks of code which can be invoked using parameters are called PL/SQL sub programs.
Advantages of PL/SQL subprograms are
- The application makes a single call to the database to run a block of statements which improves performance against running SQL multiple times. This will reduce the number of calls between the database and the application.
- PL/SQL is secure since the code resides inside the database thus hiding internal database details from the application. The application will only make a call to the PL/SQL sub program
- PL/SQL and SQL go hand in hand so there would be no need of any translation required between PL/SQL and SQL.