Stored Procedures are subroutines that group SQL statements or operations to perform a specific task, processing table data on the DBMS server. They can be called from an external application.
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.
Learning Center topics
|•||(Alt+F1) | Enterprise Architect | Database Engineering | Physical Data Model | Stored Procedures|