Frends.Oracle.ExecuteProcedure / 2.5.0

Summary

Calls a stored procedure or function, returning its output parameters as well as any result set, with control over how the data comes back.

Typical use — Oracle databases where the write logic lives in packages rather than in the Process

Properties for the query to be executed.

Name	Type	Default	Example	Description
Command	`String`	–	`"SpGetResultsByAge"`	Query to be executed in string format.
CommandType	`OracleCommandType`	`StoredProcedure`	`Type.StoredProcedure`	Type of the command: Command or Stored Procedure. Possible values: `Command`: Used to make commands in the CommandType.Text `StoredProcedure`: Used to call stored procedures as CommandType.StoredProcedure
Parameters	`InputParameter[]`	–	`{ Name = "ParamName", Value = "1", DataType = QueryParameterType.NVarchar2 }`	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.