Powershell + DB-Abfrage + Result

clear-host
$res_array=0

$odpAssemblyName = "Oracle.DataAccess, Version=2.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"   
[System.Reflection.Assembly]::Load($odpAssemblyName) 
 
$conn = New-Object Oracle.DataAccess.Client.OracleConnection

#Function to Open connection to oracle DB

function Connect-Oracle{
        [CmdletBinding()]
        param(
            [string] $connectionString = $(throw "connectionString is required")  
        )
   
$conn= New-Object Oracle.DataAccess.Client.OracleConnection($connectionString)
$conn.Open()
Write-Output $conn
}


#Create connection string with database settings


function Get-ConnectionString{
        [CmdletBinding()]
        param(
            [string]$user = "dbuser",  
            [string]$pass = "dbpw",  
            [string]$hostName = "meindbserver",  
            [string]$port = "1521",  
            [string]$sid = "test"  
        )
$dataSource = ("(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST={0})(PORT={1}))(CONNECT_DATA=(SERVICE_NAME={2})))" -f $hostName, $port, $sid)  
Write-Output ("Data Source={0};User Id={1};Password={2}" -f $dataSource, $user, $pass)  
}


# Starts the connection
$conn = Connect-Oracle (Get-ConnectionString) 

# Get connection state and Server version
"Connection state is {0}, Server Version is {1}" -f $conn.State, $conn.ServerVersion  


function Get-DataTable{
        [CmdletBinding()]
        Param(
            [Parameter(Mandatory=$true)]
            [Oracle.DataAccess.Client.OracleConnection]$conn,
            [Parameter(Mandatory=$true)]
            [string]$sql
        )
$cmd = New-Object Oracle.DataAccess.Client.OracleCommand($sql,$conn)
$da = New-Object Oracle.DataAccess.Client.OracleDataAdapter($cmd)
$dt = New-Object System.Data.DataTable
[void]$da.Fill($dt)
return ,$dt
}

#SQL query

$SQLquery = "select count(*) from  sysadm.tbljob"  

#Executes query

$dt = Get-DataTable $conn $SQLquery

#Counts returned rows
Write-Host "Retrieved records:"  $dt.Rows.Count -ForegroundColor Yellow           

#Terminates the connection
$conn.Close()

# Returns connection state
"Connection state is {0}" -f $conn.State