Advantage of using stored procedures?

Answer 1

It helps you to build powerful database applications, stored procedures provide several advantages including better performance, higher productivity, ease of use, and increased scalability.

Credit:http://docs.oracle.com/cd/F49540_01/DOC/java.815/a64686/01_intr3.htm

Answer 2

Here are some :

---

• Stored Procedures are compiled and stored in executable form and that's why procedure calls are quick and efficient.
• Provides a "public interface" to a database (another abstraction layer).
  Also groups all queries at the same location, making it easier for DBAs to see how the database is queried and optimize it accordingly.
• By using SPs, you also avoid having to give users direct access to tables. All access can be controlled via the SPs
• Another advantage to using stored procedures, especially in medium to large scale web sites or applications, is the data functionality is separated from the application making it easier to manage, document, and maintain. For example, if an application updates the customer table in ten different places, there can be a single stored procedure and a standard procedure call from the application for this functionality. If a change needs to be made to the way a customer record is managed, then the SQL statements only need to be changed in one place, in the database layer