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

[Parameter(Mandatory=$false)][Oracle.DataAccess.Client.
OracleConnection]$conn,
[Parameter(Mandatory=$true)][string]$sql,
[Parameter(Mandatory=$false)][Hashtable]$paramValues,
[Parameter(Mandatory=$false)][switch]$passThru
)
$conn = Get-Connection($conn)
$cmd = New-Object Oracle.DataAccess.Client.
OracleCommand($sql,$conn)
Set-CommandParamsFromArray $cmd $paramValues
$trans = $conn.BeginTransaction()
$result = $cmd.ExecuteNonQuery(); $cmd.Dispose()
if ($psCmdlet.ShouldProcess($conn.DataSource)) {
$trans.Commit()
}
else {
$trans.Rollback(); "$result row(s) affected"
}
if ($passThru) { $result }
}

8. At the bottom of the script, use Export-ModuleMember to deine the functions to

be made public and automatically load ODP.NET:
Export-ModuleMember -Function Connect,Connect-TNS,Disconnect,Get-
DataTable,Invoke
Load -version $OdpVersion

9. Open a PowerShell command prompt and import the module:

PS > Import-Module Oracle.DataAccess -Prefix Oracle -ArgumentList
2

10. List the commands available in the module:
PS > Get-Command -Module Oracle.DataAccess | ft -auto

CommandType Name Definition
----------- ---- ----------
Function Connect-OracleTNS ...
Function Get-OracleDataTable ...
Function OracleConnect ...
Function OracleDisconnect ...
Function OracleInvoke ...