Stored procedures

Overview

Stored procedures are operations annotated <<storedProcedure>>, which can be modeled in the logical or the physical model.

Figure 41 and the code which follows show an example of a stored procedure.

Figure 41. Example of a stored procedure

The generated SQL file will contain the following for SQL Server:

/*****************************************************/

/* Generation of "Operation" stored procedure */

/*****************************************************/

BEGIN tran

go

CREATE PROCEDURE Operation (

@p1 INTEGER,

@p2 DECIMAL )

AS

..

..

go

COMMIT tran

go

Stored procedure parameter types

As with attributes, the types of stored procedure parameters can be customized using either the properties editor or the {sqlType} tagged value. For further information on type mapping, please see the "Attributes" section in the current chapter of this user guide.