Please note : This help page is for an older version of Enteprise Archtiect. 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.

Topics

Topic

Detail

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