Stored Procedure

A subroutine available to applications that access a relational database system. A stored procedure is actually stored in the database data dictionary. In a database management system, a stored procedure is a precompiled set of SQL statements that can be shared with a number of programs. The use of stored procedures can be helpful in controlling access to data (end-users may enter or change data but do not write procedures), preserving data integrity (information is entered in a consistent manner), and improving productivity (statements in a stored procedure only need to be written one time).