|
| Command | | (Required) When this is an attribute of Procedure.SP, provide the name of a Stored Procedure that returns a single or no values. Use this element for procedures that execute UPDATEs, INSERTs, and other database actions.
When this is an attribute of DataLayer.SP, provide the name of a Stored Procedure that returns a result set of some number of data rows.
If working with Oracle Packages, provide the Package name, then a period, then the Procedure name. For example, "myPackage.myProcedure".
|
| ConnectionID | | Specifies a connection to a data source that is defined in the Settings.
For elements connecting to relational databases, default is the first Connection element in _settings.lgx. |
| ID | | (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. |
| SPReturnType | | Sets the return type for a Procedure.SP element.
"ReturnValue" will return only the first column of the first row (if any). Additional columns or rows are ignored.
Access this value with an @Procedure "rdReturnValue" token, for example:
@Procedure.myProcedureId.rdReturnValue~
"FirstRow" returns the first row of data returned by the stored procedure. Access the values of the first row with @Procedure tokens. For example:
@Procedure.myProcedureId.someColumnName~
"ReturnValue" is the default value for SPReturnType. |