Procedure Property Sheet Parameters Tab

This tab lists the call parameters of the procedure. Stored procedures can use parameters to accept values from and return values to the calling replication process.

In the following example, the rs_delexception procedure used to delete a transaction in the exceptions log takes the transaction_id parameter, which specifies the number of the transaction to delete.

procedure parameter

Each parameter contains the following properties:

Property

Description

Name

Specifies the name of the item, which should be clear and meaningful, and should convey the item's purpose to non-technical users.

Code

Specifies the technical name of the object, which is used for generating code or scripts.

Comment

Specifies a descriptive comment for the object.

Stereotype

Extends the semantics of an object derived from existing objects but specific to your needs. You can enter stereotypes directly in this field, or add stereotypes to the list by specifying them in your model's resource file or in an extended model definition.

Procedure

[read-only] Specifies the procedure to which the parameter belongs.

Data type

Specifies the data type of the parameter.

Length

Specifies the maximum length of the data type.

Precision

Specifies the maximum number of places after the decimal point.