Purpose and Main Features: Procedure

The Procedure object enables the user to create procedures and functions for various DBMS.

Unlike the DBMS command, a stored procedure or function is created on the server when the Procedure object is created in the repository. Several repository procedures may refer to the same stored procedure on database server. Changes in text of a stored procedure affect all objects referring to this procedure. The result of a procedure is the number of processed records, or some specific value if a function is created instead of a procedure.

After executing one of the operations, the procedure creation wizard opens containing the pages:

To start the selected procedure, select one of the operations:

In the web application:

Select the Open item in the object's context menu.
Select the Open in a New Tab item in the object's context menu.
Select the Open in a New Window item in the object's context menu.
Double-click the object.

In the desktop application:

Click the Open button in the Open group on the Home ribbon tab.
Click the Open > In Default Tool button in the Open group on the Home ribbon tab.
Select the Open item in the object's context menu.
Double-click the object.

NOTE. Creating of procedures and functions is unavailable in SQLite DBMS and HP Vertica DBMS because such object type is missing in these DBMS.

Version Control

If the repository connected to version control system, the procedure can be added to the system to control changes in its version. To do this, select the Add to VCS context menu item for the procedure in the object navigator. After adding the object to VCS server one can track its changes. Version control system stores procedure text and parameter settings. For details about working with objects added to the version control system, see the Developing Applications in a Team section.