SHOW:
|
|
- or go back to the newest paste.
1 | #Oracle Strings | |
2 | [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 | |
3 | $constr = "User Id=<>;Password=<>;Data Source=<>" | |
4 | $conn = New-Object Oracle.DataAccess.Client.OracleConnection($constr) | |
5 | $conn.Open() | |
6 | $sSQL = "<Query>" | |
7 | - | $sSQL_AGR = "select AGR_SNAME from tAgreement where agr_lkey = 110338" |
7 | + | |
8 | - | $sSQL_MBS = "select MBS_SNAME from MBS_Search where mbs_lkey =" |
8 | + | |
9 | #.... | |
10 | - | $commandAGR = New-Object Oracle.DataAccess.Client.OracleCommand($sSQL_AGR,$conn) |
10 | + | |
11 | - | $commandMBS = New-Object Oracle.DataAccess.Client.OracleCommand($sSQL_MBS,$conn) |
11 | + | |
12 | for ($a=0;$a -lt $reader.FieldCount;$a++){} | |
13 | ||
14 | While ($reader.read()) { | |
15 | $str1=$reader.Getstring(0) #This is the first column value. You can assign others to Getstring(1) | |
16 | $Var1 = <Do something with> $str1 | |
17 | } |