PowershellでOracleのデータベースに接続「ODP.NET」

[void][Reflection.Assembly]::LoadFile("Oracle.DataAccess.dllのパス")

$cs = "Data Source=データソース;User ID=ユーザーID;Password=パスワード"
$sql = "SELECT * FROM DUAL"

$con = New-Object Oracle.DataAccess.Client.OracleConnection($cs)
$con.Open()

$cmd = New-Object Oracle.DataAccess.Client.OracleCommand($sql, $con)
$rec = $cmd.ExecuteReader()
while($rec.read()) {
    Write-Host $rec[0]
}

$con.Close()