# Load the ODP assembly 
[Reflection.Assembly]::LoadFile("C:\app\tmaanen\product\11.1.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll")
#connect to Oracle 
$constr = "User Id=hr;Password=bunvegni;Data Source=LINUX"
$connString= New-Object Oracle.DataAccess.Client.OracleConnection($constr)
$connString.Open()
$query = "select * from hr.employees"
$da = New-Object Oracle.DataAccess.Client.OracleCommand( $query,$connString)
$reader=$da.ExecuteReader()
# Write out the results 
for ($i=0;$i -lt $reader.FieldCount;$i++) {
    Write-Host  $reader.GetName($i) $reader.GetDataTypeName($i) 
}
while ($reader.read()) {
    $employee_id=$reader.GetDecimal(0)
    $first_name=$reader.GetString(1)  
    $last_name=$reader.GetString(2)  
    $EMAIL=$reader.GetString(3) 
    $PHONE_NUMBER=$reader.GetString(4) 
    $HIRE_DATE=$reader.GetDateTime(5)
    $JOB_ID=$reader.GetString(6)
    $SALARY=$reader.GetDecimal(7)
    if ( $reader.IsDBNull(8) ) { $COMMISSION_PCT = ""} else {$COMMISSION_PCT=$reader.GetDecimal(8)}
    if ( $reader.IsDBNull(9) ) { $MANAGER_ID = ""} else {$MANAGER_ID=$reader.GetDecimal(9)}
    if ( $reader.IsDBNull(10) ) { $DEPARTMENT_ID = ""} else {$DEPARTMENT_ID=$reader.GetDecimal(10)}

    Write-Host "$employee_id; ""$first_name""; ""$last_name""; ""$EMAIL""; ""$PHONE_NUMBER""; $HIRE_DATE; ""$JOB_ID""; $SALARY; $MANAGER_ID; $DEPARTMENT_ID"
}

echo " >>>>>>   EINDE  <<<<<<<<<< "
$connString.close