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.

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

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