Purposes and advantages of stored procedures:

Manage, control and validate data

It can also be used for access mechanisms

Large queries can be avoided

Reduces network traffic since they need not be recompiled

Even though the stored procedure itself may be a complex piece of code, we need not write it over and over again. Hence stored procedures increases reusability of code

Permissions can be granted for stored procedures. Hence, increases security.