Advantages and Disadvantages of Stored Procedure

Question

Hi!!

Can anyone tell me the advantages and disadvantages of the stored procedures?

Answer 1

Advantages:

A Stored Procedure can be used as a modular programming which means create once, store and call for several times whenever it is required. This supports faster execution. It also reduces network traffic and provides better security to the data.

Disadvantage:

The only disadvantage of a Stored Procedure is that it can be executed only in the database and utilizes more memory in the database server.

Answer 2

https://www.quora.com/What-are-the-advantages-of-using-an-SQL-stored-procedures