Stored procedures

Kalipso - Developing - Form - Database Connection Profiles - Tables - Remote Online - Stored procedures

Stored procedures are subroutines available on the server database. Stored Procedures cannot be created in Kalipso; they have to be imported through a Remote Online Database Connection Profile.

Kalipso doesn’t support either the “Return Value” or Output Columns of Stored Procedures. If you use Output Columns in your Stored Procedures, you have to delete them in Kalipso.

To be able to receive data through a Stored Procedure, you’ll have to fill a record set.

As you can see in the image below, when connecting to an external database and it has Storage Procedures, they can be added in the visible tab.

On the right side there are icons that allow the management of Storage Procedures. They allow:

• Add - Adds a new storage procedure to the project (this option opens a new window).

• Edit - Edit a storage procedure already added. In this case, you will have to select the storage procedure in the list (this option opens a new window).

• Copy - Copies a storage procedure already added from the list.

• Paste - Paste a copied storage procedure.

• Delete - Deletes the storage procedure selected in the list.

Add / Edit

When you click on add a new storage procedure a new window appears that allows you to add it. This window is similar to the one that appears when editing an already added. Therefore, the process for both actions is described simultaneously.

Adding storage procedures is done in two steps.

Step 1

The first step is to verify if the selected database connection profile is the correct one, and the fields below reflect the data contained in the selected profile. If everything is as supposed, just click on next. Otherwise you can change the database connection profile.

Step 2

In this step, you will have to choose the storage procedure that you want to use.

In the table that appears, the storage procedures associated with the database to which it was linked appear. In addition, you can also select the:

• Owner - Option to filter the database owner.

To add just check the one desired and the task is concluded.

At the end click "Next".

The data entered in all the fields are examples.