<img src="https://queue.simpleanalyticscdn.com/noscript.gif" alt="" referrerpolicy="no-referrer-when-downgrade"/>Frends.Oracle.ExecuteQuery | Frends Task Docs
taskstemplates
feedback & roadmap30-day trialbook a demo

Frends.Oracle.ExecuteQuery / 3.1.0

Source code
Frends 5.5+Crossplatformnet6.0

Task for performing queries in Oracle database.

NameDescription
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:

  • Auto: 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.

  • NonQuery: 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.

  • Scalar: 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.

  • ExecuteReader: 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
NameDescription
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
OracleIsolationLevel : TransactionIsolationLevel

Transaction isolation level for the query. Options: - Default - ReadCommited - None - Serializable - ReadUncommited - RepeatableRead Additional information can be found from here

Possible values:

  • Default: Transaction isolation level for the query. Options:

    • Default
    • ReadCommited
    • None
    • Serializable
    • ReadUncommited
    • RepeatableRead Additional information can be found from here

  • None: Transaction isolation level for the query. Options:

    • Default
    • ReadCommited
    • None
    • Serializable
    • ReadUncommited
    • RepeatableRead Additional information can be found from here

  • ReadUncommitted: Transaction isolation level for the query. Options:

    • Default
    • ReadCommited
    • None
    • Serializable
    • ReadUncommited
    • RepeatableRead Additional information can be found from here

  • ReadCommitted: Transaction isolation level for the query. Options:

    • Default
    • ReadCommited
    • None
    • Serializable
    • ReadUncommited
    • RepeatableRead Additional information can be found from here

  • RepeatableRead: Transaction isolation level for the query. Options:

    • Default
    • ReadCommited
    • None
    • Serializable
    • ReadUncommited
    • RepeatableRead Additional information can be found from here

  • Serializable: 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
NameDescription
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": ""}]

Changelog

[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.