A DB Procedure is a special procedure executed in the database server. Like SQL statements, DB procedures can be called from any user process. They serve to combine a number of SQL statements. DB procedures are used for the following reasons:
- To improve performance, since a DB Procedure is processed by the database server, thus reducing communication overhead.
- To simplify programming, since complex sequences of SQL statements can be replaced by a single DB Procedure call.
- To simplify granting privileges, since it is not necessary to grant privileges for the database objects accessed beyond the call privilege for a DB Procedure.
Relationships between a DB procedure and other objects:
1. Dbprocedure Refers to Module
2. Module Calls Dbprocedure
3. User Uses Dbprocedure
1. A DB procedure is implemented by a specific module; a module can be used as a DB procedure (0-1).
2. A module can call a number of DB procedures; a DB procedure can be called by a number of modules (N[0]-M[0]).
3. A user can have execute privileges for a number of DB procedures; a DB procedure can be used by one or more users (N-M[0]).
See also:
Managing Execute Privileges for DB Procedures