Stored Procedures

Stored Procedures are subroutines for processing table data on the DBMS server. These routines can be called from an external application.




See also

What is a Stored Procedure?

A stored procedure is a group of SQL statements that perform a specific task; they are used to group a set of operations or queries that can be executed on a database server.

Stored Procedures are often used where there is a need to reduce network usage between clients and the DBMS servers.

Enterprise Architect models stored procedures using stereotyped UML Classes and Operations. These can be generated with a schema for loading onto the DBMS server.

Import Database Schema



Create a Stored Procedure

DBMS Product Conversion for a Package


Learning Center topics

(Alt+F1) | Database Engineering | Physical Data Model | Stored Procedures