• Processing complex transactions is easier for the user because the details of access to underlying table and views are encapsulated within the procedure. This allows a less experienced user to process the data and can ensure that business rules are enforced by the stored procedure when the data is accessed by the client application.

• Using stored procedures can reduce network traffic. For example, a database procedure can be invoked with one execute statement. This invoked procedure can issue multiple SQL statements. Only the invocation of the stored procedure and its response flow over the network.

• Database procedures can be shared by multiple clients because they are stored in the server and not the client. This reduces administration costs and allows complex application logic to be managed in the server instead of at each client system.