Working with Stored Procedures |
|
A stored procedure is a special kind of user-defined function that contains embedded SQL statements. This allows you to bypass repeated SQL compilation and optimization, increasing the performance of frequently repeated tasks. You can execute a stored procedure as a command in interactive SQL, or invoke it in application programs, trigger actions, or other stored procedures. You can accomplish a wide range of objectives with stored procedures, including improving database performance, simplifying the writing of applications, and limiting or monitoring access to a database. Because a stored procedure is stored in an executable object in the database, it is available to every application running on the database. Several applications can use the same stored procedure and hence the development time for an application is reduced.
Related topic:
Creating
a Stored Procedure
Executing a Stored Procedure
Dropping a Stored Procedure
Granting Privileges on Stored Procedures