Frends.Oracle.ExecuteQuery / 4.0.0
Summary
Runs SQL against Oracle, returning rows or an affected count depending on the statement, with parameters passed separately from the text.
Typical use — reading from and writing to Oracle; parameterising rather than concatenating is also what keeps injection out of the query
Properties for the query to be executed.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| Query | String |
INSERT INTO MyTable (id, first_name, last_name) VALUES (:id, :first_name, :last_name) |
"INSERT INTO MyTable (id, first_name, last_name) VALUES (:id, :first_name, :last_name)" |
Query to be executed in string format. |
| Parameters | QueryParameter[] |
– | [
{ Name = "id", Value = 1, DataType = QueryParameterType.Int32 },
{ Name = "first_name", Value = "John", DataType = QueryParameterType.Varchar2 },
{ Name = "last_name", Value = "Doe", DataType = QueryParameterType.Varchar2 }
] |
Parameters for the database query. |
| ConnectionStringSecret | String |
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword; |
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword; |
Oracle connection string. |
| ExecuteType | ExecuteTypes |
Auto |
ExecuteType.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. Possible values:
|