PowerShell code
add-type -path $pwd\Oracle.ManagedDataAccess.core.23.26.0.dll
$ora = new-object Oracle.ManagedDataAccess.Client.OracleConnection('User Id=elar;Password=elar;Data Source=SVA10MIG')
$ora.Open()
$cmd = $ora.CreateCommand()
$cmd.CommandText = "select object_name, subobject_name from all_objects where rownum < 50" # subobject_name likely contains NULL values
$rdr = $cmd.ExecuteReader()
while ($rdr.Read()) {
write-host "$($rdr.GetString(0)) - $($rdr.GetString(1))"
}
$ora.Close()
write-host "$($rdr.GetString(0)) - $($rdr.IsDBNull(1) ? '' : $rdr.GetString(1))"