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()) {
…
}