Instant Oracle Database and PowerShell How-to - Instant Oracle Database and PowerShell How-to - page 46

}
}

function Connect-TNS {
[CmdletBinding()]
Param(
[Parameter(Mandatory=$true)] [string]$TNS,
[Parameter(Mandatory=$true)] [string]$UserId,
[Parameter(Mandatory=$true)] [string]$Password,
[Parameter(Mandatory=$false)] [switch]$PassThru )
$connectString = ("Data Source={0};User Id={1};Password={2};"
-f $TNS, $UserId, $Password)
Connect $connectString -PassThru:$PassThru
}

6. Deine functions to resolve a connection and to disconnect:
function Get-Connection ($conn) {
if (!$conn) { $conn = $SCRIPT:conn }
$conn
}

function Disconnect {
[CmdletBinding()]
Param(
[Parameter(Mandatory=$false)]
[Oracle.DataAccess.Client.OracleConnection]$conn)
$conn = Get-Connection($conn)
if (!$conn) {
Write-Verbose "No connection is available to disconnect
from"; return
}
if ($conn -and $conn.State -eq [System.Data.
ConnectionState]::Closed) {
Write-Verbose "Connection is already closed"; return
}
$conn.Close()
Write-Verbose ("Closed connection to {0}" -f $conn.
ConnectionString)
$conn.Dispose()
}

7. Add -WhatIf support to a function for executing non-query methods:

function Invoke {
[CmdletBinding(SupportsShouldProcess = $true)]
Param(