Element Details: SP+Parameter
 Back


Available in: Logi Info Source code name: SPParameter

SPParameters specify the parameters for a Stored Procedure. Parameters should be listed in order.

The ID value does not have to correspond to a parameter name.

The Size can be 0, and will then be adjusted to the actual size of the Input Value. Do not specify the return parameter - it is automatic.

In a Report or ETL job definition, the Stored Procedure may return a rowset. For Oracle, rowsets can be returned by a Package as a REF CURSOR.

In a Process definition, you can use output parameters when SPParamDirection="Output". Access the the return values with an @Procedure token, for example:

@Procedure.myProcedureId.myOutputParam~



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
SPParamDirection
Return
Output
Input
(Required) Specifies the direction of a Stored Procedure Parameter, usually "Input". Otherwise, set to "Return" or "Output".
SPParamSize
(Number)
(Required) Specifies the size or length of a Stored Procedure Parameter. If set to 0, the size is automatically set at runtime to the actual length of the Value.
SPParamType
dt-8
dt-72
dt-7
dt-64
dt-6
dt-5
dt-4
dt-3
dt-21
dt-205
dt-204
dt-203
dt-202
dt-201
dt-200
dt-20
dt-2
dt-19
dt-18
dt-17
dt-16
dt-14
dt-139
dt-135
dt-134
dt-133
dt-132
dt-131
dt-130
dt-129
dt-12
dt-11
dt-0
(Required) The data type of the Stored Procedure parameter.
Value
UserDefined
A value for the element.



PARENT ELEMENTS

Click element to drill down for more information.

SP Parameters Vpd Context


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top