Element Details: Execute.SP
 Back


Available in: Logi Info Source code name: Execute.SP

Runs a database stored procedure.

Define parameters for the SP with an SPParameters element, and an SPParameter element for each.

You can reference the SP's output values with a Procedure token. For example:

@Etl.myProcedureID.myParameterID~

Use "rdReturnValue" to get the SP's return value.

@Etl.myProcedureID.rdReturnValue~.

DataLayer.SP works with OLEDB/Application and MySQL database connections. For other connection types, use EXECUTE or CALL commands to run stored procedures.

Also returns the first row of a rowset returned. Access the values of the first row with @Etl tokens.

For example: @Etl.myProcedureId.someColumnName~



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
Command
UserDefined
(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
UserDefined
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
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.



PARENT ELEMENTS

Click element to drill down for more information.

Etl Job
If 		If ETL Error
If File Exists 		If Folder Exists Loop.Data Layer Rows


CHILD ELEMENTS

Click element to drill down for more information.

If ETL Error SP Parameters


 Back to top


Chart Debug