Oracle Connection String

#Oracle Strings
[Reflection.Assembly]::LoadFile("C:\oracle\product\10.2.0\client_1\odp.net\bin\2.x\Oracle.DataAccess.dll") #Obviously this path needs to be correct
$constr = "User Id=<>;Password=<>;Data Source=<>"
$conn = New-Object Oracle.DataAccess.Client.OracleConnection($constr)
$conn.Open()
$sSQL = "<Query>"
$sSQL_AGR = "select AGR_SNAME from tAgreement where agr_lkey = 110338"
$sSQL_MBS = "select MBS_SNAME from MBS_Search where mbs_lkey ="
$command = New-Object Oracle.DataAccess.Client.OracleCommand($sSQL,$conn)
$commandAGR = New-Object Oracle.DataAccess.Client.OracleCommand($sSQL_AGR,$conn)
$commandMBS = New-Object Oracle.DataAccess.Client.OracleCommand($sSQL_MBS,$conn)

#....

$reader=$command.ExecuteReader()
    for ($a=0;$a -lt $reader.FieldCount;$a++){}

            While ($reader.read())  {
                    $str1=$reader.Getstring(0)  #This is the first column value. You can assign others to Getstring(1)
                    $Var1 = <Do something with> $str1
                        }