Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

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