Oracle.DataAccess.Client.OracleParameter (class)

Oracle.DataAccess.Client.OracleParameter derives from System.Data.Common.DbParameter.

The data type of an Oracle.DataAccess.Client.OracleParameter is specified by a Oracle.DataAccess.Client.OracleDbType enum.

PowerShell example

A simple PowerShell fragment that tries to demonstrate how Oracle.DataAccess.Client.OracleParameter might be used in PowerShell.

The type of $par (which is returned by $sql.Parameters.Add) is Oracle.DataAccess.Client.OracleParameter.

param (
   [string] $name = $null
)

add-type -path "$env:oracle_home\odp.net\bin\4\Oracle.DataAccess.dll"

$conn = [Oracle.DataAccess.Client.OracleConnection]::new("User ID=rene;Password=rene;data source=ora19")
$conn.Open()

if ($filename) {
   $sql  = [Oracle.DataAccess.Client.OracleCommand]::new("select * from tab where name = :1", $conn)
   $par  = $sql.Parameters.Add('name', [Oracle.DataAccess.Client.OracleDbType]::Varchar2, $name, [System.Data.ParameterDirection]::Input)
}
else {
   $sql  = [Oracle.DataAccess.Client.OracleCommand]::new("select * from tab", $conn)
}
$sql.CommandType = [System.Data.CommandType]::Text

$rdr = $sql.ExecuteReader()

while ($rdr.Read()) {
  …
}