ExecuteProcedure
Execute a stored procedure to MySQL.
Last updated
Was this helpful?
Execute a stored procedure to MySQL.
Task version: 1.1.0
Required Frends version: 5.5+
Required .NET version: 6.0
Compatible Agents: Crossplatform
Source code: https://github.com/FrendsPlatform/Frends.Salesforce/tree/main/Frends.MySQL.ExecuteProcedure
🗝ConnectionString : String
Mysql connection string
Default: server=server;user=user;database=db;password=pw;
Example: server=server;user=user;database=db;password=pw;
Query : String
SQL statement to execute at the data source. Usually query or name of a stored procedure. https://dev.mysql.com/doc/dev/connector-net/8.0/html/P_MySql_Data_MySqlClient_MySqlCommand_CommandText.htm
Default: ProcedureName
Example: SELECT ColumnName FROM TableName
Parameters : Parameter[]
Parameters for the database query
Default: -
Example: Name: ValueName
TimeoutSeconds : Int32
Timeout value in seconds
Default: 30
Example: 30
TransactionIsolationLevel : TransactionIsolationLevel
Transaction isolation level to use.
Possible values:
ReadCommitted: Transaction isolation level to use.
Serializable: Transaction isolation level to use.
ReadUncommitted: Transaction isolation level to use.
RepeatableRead: Transaction isolation level to use.
Default: 3
Example: ReadCommited
AffectedRows : Int32
Count of affected rows
Example: 10
Changelog is not available for this Task.
Last updated
Was this helpful?
Was this helpful?