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

Query to be executed in string format.


Default: INSERT INTO MyTable (id, first\_name, last\_name) VALUES (:id, :first\_name, :last\_name)
Example: "INSERT INTO MyTable (id, first\_name, last\_name) VALUES (:id, :first\_name, :last\_name)"

| | Parameters : `QueryParameter[]` |

Parameters for the database query.


Default: -
Example: \[ { Name = "id", Value = 1, DataType = QueryParameterType.Int32 }, { Name = "first\_name", Value = "John", DataType = QueryParameterType.Varchar2 }, { Name = "last\_name", Value = "Doe", DataType = QueryParameterType.Varchar2 } ]

| | 🗝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;

| | ExecuteType : `ExecuteTypes` |

Specifies how a command string is interpreted.

Auto: ExecuteReader for SELECT-query and NonQuery for UPDATE, INSERT, or DELETE statements.

ExecuteReader: Use this operation to execute any arbitrary SQL statements in Oracle if you want the result set to be returned.

NonQuery: Use this operation to execute any arbitrary SQL statements in Oracle if you do not want any result set to be returned. You can use this operation to create database objects or change data in a database by executing UPDATE, INSERT, or DELETE statements. The return value of this operation is of Int32 data type, and For the UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the SQL statement. For all other types of statements, the return value is -1.

Scalar: Use this operation to execute any arbitrary SQL statements in Oracle to return a single value. This operation returns the value only in the first column of the first row in the result set returned by the SQL statement.

Possible values:

Specifies how a command string is interpreted.

Auto: ExecuteReader for SELECT-query and NonQuery for UPDATE, INSERT, or DELETE statements.

ExecuteReader: Use this operation to execute any arbitrary SQL statements in Oracle if you want the result set to be returned.

NonQuery: Use this operation to execute any arbitrary SQL statements in Oracle if you do not want any result set to be returned. You can use this operation to create database objects or change data in a database by executing UPDATE, INSERT, or DELETE statements. The return value of this operation is of Int32 data type, and For the UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the SQL statement. For all other types of statements, the return value is -1.

Scalar: Use this operation to execute any arbitrary SQL statements in Oracle to return a single value. This operation returns the value only in the first column of the first row in the result set returned by the SQL statement.

Specifies how a command string is interpreted.

Auto: ExecuteReader for SELECT-query and NonQuery for UPDATE, INSERT, or DELETE statements.

ExecuteReader: Use this operation to execute any arbitrary SQL statements in Oracle if you want the result set to be returned.

NonQuery: Use this operation to execute any arbitrary SQL statements in Oracle if you do not want any result set to be returned. You can use this operation to create database objects or change data in a database by executing UPDATE, INSERT, or DELETE statements. The return value of this operation is of Int32 data type, and For the UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the SQL statement. For all other types of statements, the return value is -1.

Scalar: Use this operation to execute any arbitrary SQL statements in Oracle to return a single value. This operation returns the value only in the first column of the first row in the result set returned by the SQL statement.

Specifies how a command string is interpreted.

Auto: ExecuteReader for SELECT-query and NonQuery for UPDATE, INSERT, or DELETE statements.

ExecuteReader: Use this operation to execute any arbitrary SQL statements in Oracle if you want the result set to be returned.

NonQuery: Use this operation to execute any arbitrary SQL statements in Oracle if you do not want any result set to be returned. You can use this operation to create database objects or change data in a database by executing UPDATE, INSERT, or DELETE statements. The return value of this operation is of Int32 data type, and For the UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the SQL statement. For all other types of statements, the return value is -1.

Scalar: Use this operation to execute any arbitrary SQL statements in Oracle to return a single value. This operation returns the value only in the first column of the first row in the result set returned by the SQL statement.

Specifies how a command string is interpreted.

Auto: ExecuteReader for SELECT-query and NonQuery for UPDATE, INSERT, or DELETE statements.

ExecuteReader: Use this operation to execute any arbitrary SQL statements in Oracle if you want the result set to be returned.

NonQuery: Use this operation to execute any arbitrary SQL statements in Oracle if you do not want any result set to be returned. You can use this operation to create database objects or change data in a database by executing UPDATE, INSERT, or DELETE statements. The return value of this operation is of Int32 data type, and For the UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the SQL statement. For all other types of statements, the return value is -1.

Scalar: Use this operation to execute any arbitrary SQL statements in Oracle to return a single value. This operation returns the value only in the first column of the first row in the result set returned by the SQL statement.


Default: 0
Example: ExecuteType.ExecuteReader

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

Choose if an error should be thrown if the Task fails.

Otherwise, returns Object { Success = false }


Default: True
Example: true

| | TimeoutSeconds : `Int32` |

Timeout value in seconds.


Default: 30
Example: 30

| | OracleIsolationLevel : `TransactionIsolationLevel` |

Transaction isolation level for the query.

Options:

- Default

- ReadCommited

- None

- Serializable

- ReadUncommited

- RepeatableRead

Additional information can be found from here

Possible values:

Transaction isolation level for the query.

Options:

- Default

- ReadCommited

- None

- Serializable

- ReadUncommited

- RepeatableRead

Additional information can be found from here

Transaction isolation level for the query.

Options:

- Default

- ReadCommited

- None

- Serializable

- ReadUncommited

- RepeatableRead

Additional information can be found from here

Transaction isolation level for the query.

Options:

- Default

- ReadCommited

- None

- Serializable

- ReadUncommited

- RepeatableRead

Additional information can be found from here

Transaction isolation level for the query.

Options:

- Default

- ReadCommited

- None

- Serializable

- ReadUncommited

- RepeatableRead

Additional information can be found from here

Transaction isolation level for the query.

Options:

- Default

- ReadCommited

- None

- Serializable

- ReadUncommited

- RepeatableRead

Additional information can be found from here

Transaction isolation level for the query.

Options:

- Default

- ReadCommited

- None

- Serializable

- ReadUncommited

- RepeatableRead

Additional information can be found from here


Default: 0
Example: Default

| | BindParameterByName : `Boolean` |

Choose to bind the parameter by name.

If set to false parameter order is crucial.


Default: True
Example: true

| | EnableSafeNumericMapping : `Boolean` |

When true, attempts to safely map high-precision Oracle numbers to .NET types

by rounding the scale. (Oracle can store up to 38 digits, while .NET only 29)

Note: Whole numbers exceeding 29 digits may still fail


Default: False
Example: false

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

Boolean value of success of the query
Example: true

| | Message : `String` |

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

| | Output : `Object` |

List of JObjects showing the output of the query.
Example: \[{"ID": "1","FIRST\_NAME": "Saija","LAST\_NAME": "Saijalainen","START\_DATE": ""}]

| | {% endtab %} | | {% tab title="Changelog" %} ## Changelog ### \[4.0.0] - 2026-02-26 #### Fixed * Fixed the issue with converting query results to JToken in Auto mode. #### Added * **\[Breaking Change]** Added an option to enable rounding of decimal values. #### Changed * Error related to parsing values is more descriptive now. * **\[Breaking Change]** Normalize behavior between Auto and ExecuteReader mode. ### \[3.2.0] - 2025-03-25 #### Changed * Update packages: Microsoft.Extensions.DependencyInjection 5.0.1 -> 9.0.3 Oracle.ManagedDataAccess.Core 3.21.170 -> 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 ### \[3.1.0] - 2025-03-25 #### Fixed * Fixed issue with converting query results to JToken. * Updated Newtonsoft.Json to version 13.0.3. * Updated Oracle.ManagedDataAccess.Core to version 3.21.170. ### \[3.0.0] - 2025-03-24 #### Added * \[Breaking] New 'ExecuteType' parameter to control how SQL command string is executed. * Default value for new parameter is 'Auto' * Use the default parameter if you want the Task to work as before. ### \[2.0.1] - 2022-11-04 #### Fixed * Fixed issue which resulted to task not able to close connection. ### \[2.0.0] - 2022-10-31 #### Fixed * \[Breaking] Simplified implementation and merged ConnectionProperties and QueryProperties classes into one Input class. * Changed the result output object to be dynamic to enable dot notation. * Changed the implementation to resemble other database related tasks. * Modified the task to be asynchronous. * Changed the task use different methods when doing 'select' query and when doing other queries. * Updated workflow for Linux based testing and enabled the tests. ### \[1.0.0] - 2022-04-22 #### Added * Initial implementation. {% endtab %} {% endtabs %}