Instant Oracle Database and PowerShell How-to - Instant Oracle Database and PowerShell How-to - page 19

)
$cmd = New-Object Oracle.DataAccess.Client.
OracleCommand($sql,$conn)
$cmd.BindByName = $true
$idParam = $null
if ($idColumn)
{
$cmd.CommandText = "{0} RETURNING {1} INTO :{2} " -f $cmd.
CommandText, $idColumn, $idColumn
$idParam = New-Object Oracle.DataAccess.Client.
OracleParameter
$idParam.Direction = [System.Data.
ParameterDirection]::Output
$idParam.DbType = [System.Data.DbType]::Int32
$idParam.Value = [DBNull]::Value
$idParam.SourceColumn = $idColumn
$idParam.ParameterName = $idColumn
$cmd.Parameters.Add($idParam) | Out-Null
}
if ($paramValues)
{
foreach ($p in $paramValues.GetEnumerator())
{
$oraParam = New-Object Oracle.DataAccess.Client.
OracleParameter
$oraParam.ParameterName = $p.Key
$oraParam.Value = $p.Value
$cmd.Parameters.Add($oraParam) | Out-Null
}
}
$result = $cmd.ExecuteNonQuery()
if ($idParam)
{
if ($idParam.Value -ne [DBNull]::Value) { $idParam.Value }
else { $null }
$idParam.Dispose()
}
$cmd.Dispose()
}