Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Oracle Strings
- [Reflection.Assembly]::LoadFile("C:\oracle\product\10.2.0\client_1\odp.net\bin\2.x\Oracle.DataAccess.dll") #Obviously this path needs to be correct
- $constr = "User Id=<>;Password=<>;Data Source=<>"
- $conn = New-Object Oracle.DataAccess.Client.OracleConnection($constr)
- $conn.Open()
- $sSQL = "<Query>"
- $command = New-Object Oracle.DataAccess.Client.OracleCommand($sSQL,$conn)
- #....
- $reader=$command.ExecuteReader()
- for ($a=0;$a -lt $reader.FieldCount;$a++){}
- While ($reader.read()) {
- $str1=$reader.Getstring(0) #This is the first column value. You can assign others to Getstring(1)
- $Var1 = <Do something with> $str1
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement