Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


When a client sequentially executes multiple SQL statements, it must send each SQL statement individually and wait for the result before sending the next statement. This increases the amount of time and expense that is required for communication between the server and client. In contrast, a program that is authored such that it uses stored procedures needs need to communicate with the server only one time in order to execute time so as to execute multiple SQL statements, because the client only needs to call one stored procedure comprising several SQL statements.
Therefore, using stored procedures reduces communication expensescosts, and additionally reduces the burden associated with type conversion when different data types are used on the server and client applications.


Stored procedures are stored in the database, which means that one user can execute another user's stored procedures, as long as s/he has been granted suitable as a user has been granted proper access privileges. Moreover, because stored procedures can be called from within other stored procedures, when the need arises for a new business process that is based on an existing business process, the stored procedure for the new business process has only to call the stored procedure for the existing business process, thereby eliminating redundancy and increasing productivity.