# ExecuteProcedure Required Frends version: 5.5+ Required .NET version: 6.0 Compatible Agents: Crossplatform Source code: {% tabs %} {% tab title="Parameter: Input" %} | Name | Description | | --------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Command : `String` |

Query to be executed in string format.


Default: -
Example: "SpGetResultsByAge"

| | CommandType : `OracleCommandType` |

Type of the command: Command or Stored Procedure.

Possible values:

Type of the command: Command or Stored Procedure.

Type of the command: Command or Stored Procedure.


Default: 1
Example: Type.StoredProcedure

| | Parameters : `InputParameter[]` |

Parameters for the database query.


Default: -
Example: { Name = "ParamName", Value = "1", DataType = QueryParameterType.NVarchar2 }

| | 🗝ConnectionString : `String` |

Oracle connection string.


Default: Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT\_DATA=(SERVICE\_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;
Example: "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT\_DATA=(SERVICE\_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;"

| | {% endtab %} | | {% tab title="Parameter: Output" %} | Name | Description | | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | DataReturnType : `OracleCommandReturnType` |

Data type for the Result of the procedure.

Possible values:

Data type for the Result of the procedure.

Data type for the Result of the procedure.

Data type for the Result of the procedure.

Data type for the Result of the procedure.

Data type for the Result of the procedure.


Default: 1
Example: "SpGetResultsByAge"

| | OutputParameters : `OutputParameter[]` |

Parameters for the output of the procedure or command.


Default: -
Example: { Name = "name", DataType = QueryParameterType.Varchar2 }

| | {% endtab %} | | {% tab title="Parameter: Options" %} | Name | Description | | -------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | ThrowErrorOnFailure : `Boolean` |

Choose if error should be thrown if Task failes.

Otherwise returns Object { Success = false }


Default: True
Example: true

| | TimeoutSeconds : `Int32` |

Timeout value in seconds.


Default: 30
Example: 30

| | BindParameterByName : `Boolean` |

Choose to bind the parameter by name.

If set to false parameter order is crucial.


Default: True
Example: true

| | ClearConnectionPools : `Boolean` |

Choose to clear connection pools after execution.

This is an internal Oracle setting to clear cached connections.


Default: True
Example: true

| | CloseConnection : `Boolean` |

Choose to close the created connection after execution.

Setting this to false will allow the connection to be reused

but can cause issues with left open connections or concurrent usage if not handled properly.


Default: True
Example: true

| | {% endtab %} | | {% tab title="Result: Result" %} | Name | Description | | ------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Success : `Boolean` |

Boolean value of success of the query.
Example: true

| | Output : `Object` |

Content and data type depends on task output properties.
Example: \[{"ID": "1","FIRST\_NAME": "Saija","LAST\_NAME": "Saijalainen","START\_DATE": ""}]

| | Error : `String` |

String value of the Error message that comes from Oracle.
Example: "ORA-01722: invalid number"

| | {% endtab %} | | {% tab title="Changelog" %} ## Changelog ### \[2.4.0] - 2026-03-20 #### Fixed * Resolve issue with long time execution #### Added * Add new options ( `CloseConnection`, `ClearConnectionPools`) to control connection behavior. ### \[2.3.0] - 2025-12-29 #### Fixed * Improved Oracle parameter handling for NULL values and BLOBs. ### \[2.2.0] - 2025-12-02 #### Fixed * Fix missing output parameter values ### \[2.1.0] - 2025-03-25 #### Changed * Update packages: Microsoft.Extensions.DependencyInjection 6.0.0 -> 9.0.3 Newtonsoft.Json 12.0.1 -> 13.0.3 Oracle.ManagedDataAccess.Core 3.21.70 -> 23.7.0 System.ComponentModel.Annotations 4.7.0 -> 5.0.0 coverlet.collector 3.1.0 -> 6.0.4 Microsoft.NET.Test.Sdk 16.6.1 -> 17.13.0 MSTest.TestFramework 2.2.8 -> 3.8.3 nunit 3.12.0 -> 4.3.2 NUnit3TestAdapter 3.17.0 -> 5.0.0 ### \[2.0.0] - 2022-11-04 #### Fixed * \[Breaking] change the parameter implementation to resemble other database related Tasks. * Fixed issue that task was not able to close connection. ### \[1.0.0] - 2022-10-12 #### Added * Initial implementation. {% endtab %} {% endtabs %}