Advantage of stored procedures:

Stored procedures have many benefits—they can be easily modified, are reusable and they possess the ability to automate a task that requires multiple SQL statements. Another advantage of stored procedures is the ability to access or modify data in a database.

Disadvantage of stored procedures:

Restricted for complex business logic − Actually, stored procedure’s constructs are not designed for developing complex and flexible business logic. Difficult to debug − It is difficult to debug stored procedures.