The Procedure and Function page: Procedure

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

In the object navigator create an object of the Procedure type.
On the Basic Properties page of the procedure editing wizard enter the name and the identifier of created object.
Add three parameters on the Object Parameters of the procedure editing wizard:

Name	Identifier	Data type	Select the checkbox
Input	INPARAM1	Integer	Input
Function result	REZULT	String	Function result
Input2	IINPARAM2	Integer	Input

On the Procedure/Function page of the procedure editing wizard select a database, a driver, an object type, enter physical name.
In the Script field enter the following code:

(p1 in int, p2 in int)

return int

l_number int;

begin

l_number := p1+p2;

return l_number;

exception

when others then

return 0;

end;

NOTE. On enumerating input/output parameters the function parameters are used in the order from the Object Parameters page. Therefore the input parameters with the INPARAM1 identifier is transferred to the p1 variable of the function, and the parameter with the INPARAM2 identifier is transferred to the p2 variable.

Click the Finish button. A physical object is created in the DBMS repository.

In the object navigator create an object of the Procedure type.
On the Basic Properties page of the procedure editing wizard enter the name and the identifier of created object.
Add three parameters on the Object Parameters of the procedure editing wizard:

Name	Identifier	Data type	Select the checkbox
Input	PIN	Integer	Input
Input2	PIN2	Integer	Input
Input3-Output	PINOUT	Integer	Input, Output

On the Procedure/Function page of the procedure editing wizard select a database, a driver, an object type, enter physical name.
In the Script field enter the following code:

(PIn in number, PIN2 in varchar2, PINOUT in out varchar2)

begin

insert into EXECPR (field, field1, field2) values (PIN,PIN2, PINOUT);

end;

where:

PIN, PIN2, PINOUT. Procedure parameter identifiers.
EXECPR. Identifier of the table, to which values are added.
field, field1, field2. Table fields, to which values of the PIN, PIN2, PINOUT parameters are placed.

Click the Finish button. A physical object is created in the DBMS repository.

For details, see the Example of Creating a Procedure section.

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

Procedure/Function