PoshCode Archive  Artifact [2b8b3ad7f3]

Artifact 2b8b3ad7f335847137d9892437996a6149e6d70700ab1bf1eee1a78e1f5f36bc:

  • File PowerOracle.ps1 — part of check-in [5ac47fd6d3] at 2018-06-10 12:56:33 on branch trunk — Retrieve data from an Oracle database into a dataset. (user: foureight84 size: 927)

# encoding: ascii
# api: powershell
# title: PowerOracle
# description: Retrieve data from an Oracle database into a dataset.
# version: 0.1
# author: foureight84
# license: CC0
# x-poshcode-id: 1150
# x-archived: 2015-12-17T20:39:14
# x-published: 2009-06-09T14:40:00
#
# Prerequisite: Install the Oracle Data Provider for .NET > Google it! =)
#
# Load assembly
[System.Reflection.Assembly]::LoadWithPartialName("Oracle.DataAccess")

# Connection information
$ConnectionString = "Data Source=your_server/sid;User Id=user_name;Password=password"

#Standard SQL Query Syntax
$QueryString = "SELECT * FROM table_name WHERE #Case"

$OracleConnection = New-Object Oracle.DataAccess.Client.OracleConnection($ConnectionString)
$dtSet = New-Object System.Data.DataSet
$OracleAdapter = New-Object Oracle.DataAccess.Client.OracleDataAdapter($QueryString, $OracleConnection)

[void]$OracleAdapter.Fill($dtSet)