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.

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

To create the Procedure object in the object navigator click the

Create button in the main menu and select the object type on the New Object side panel.

After executing the operation the procedure creation wizard opens containing the pages:

Working with Procedure

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

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.

To edit procedure settings, select the corresponding object in the object navigator and execute the operations:

Open the procedure for edit.
Click the Settings button.

The procedure wizard opens after executing the operation. Determine settings on corresponding pages of the wizard.

Editing Procedure

To open the procedure for edit, select the corresponding object in the object navigator and execute one of the operations:

To change procedure/function text, use the Query Console panel.

The panel displays the DBMS driver in use and contains the procedure/function text specified on its creation. Create a new text in the SQL language according to the syntax that is set for the DBMS driver.

NOTE. If the PostgreSQL driver is selected, the first string of the script should contain the list of parameters and it should be in one string.

To set the specified procedure/function text for all DBMS, click the Apply for All DBMS button. After this the action confirmation dialog box opens. Confirmation is required if at least one driver differs from the current one, has non-empty procedure/function text.

To refresh procedure/function text, click the Load from Database button. Clicking this button returns a request to confirm the operation. If the answer is Yes, procedure or function text will be refreshed from database.

To execute the procedure text, click the Execute Query button.

To rename procedure:

Click on the procedure name in the Basic Settings area. The name opens in the edit mode.
Make necessary changes.
Click outside the procedure name.

To save procedure:

Click the Save button.
Confirm custom operation in the information window when going to the object navigator/procedure wizard.