windows powershell: execute select against an oracle instance. (System.Data.OracleClient)

in no way a powershell guy, but

powershell script:

[Reflection.Assembly]::LoadWithPartialName("System.Data.OracleClient") > null

 $connection=New-Object DATA.OracleClient.OracleConnection(
    "Data Source=eoxi;User Id=eoxrep;Password=***"
    )
   
 $connection.Open()
 $reader = (new-Object DATA.OracleClient.OracleCommand(
    "select * from eox.eox_log_ereignis_a where rownum < 10",
    $connection)).ExecuteReader()

 while( $Reader.Read()) {
    $id   = $reader["log_id"]
    $time = $reader["log_log_area"]
    write-output "$id $time"
 }
 $connection.Close()



executes as:

oracle select

 GAC    Version        Location
---    -------        --------
True   v2.0.50727     C:\Windows\assembly\GAC_32\System.Data.OracleClient
174063524 ww Data Import: ISIN nicht gefunden: LU0097188931
174063532 ww Data Import: ISIN nicht gefunden: DE000A0MQR19
174063533 ww Data Import: ISIN nicht gefunden: LU0418839287
174063534 ww Data Import: ISIN nicht gefunden: LU0418837232
174063538 ww Data Import: ISIN nicht gefunden: DE000A1J3N83
174063507 gateUpload Startup
174063511 V-Buchungsdatum: 25.03.2015 00:00:00
174063512 Fonds werden geladen...
174063514 Fonds (12123) laden beendet 03:40:14.1277410.

Kommentare

Kommentar veröffentlichen

Beliebte Posts aus diesem Blog

using the birt runtime with spring boot and gradle to generate PDF from a Report Design File

Warning: at the moment not recommended as solution. Personal Note (too complicated to keep in my brain / transient memory) birt simply does not think in this way: push data into report vs pull datasource, osgi vs. maven, design time jars.... Step 1: use with gradle: get dependencies from maven repo: compile ( group : 'org.eclipse.birt.runtime' , name : 'org.eclipse.birt.runtime' , version : '4.4.1' ) {    exclude module : 'flute'    exclude module : 'org.eclipse.orbit.mongodb' } // also working 4.2.1a  // not compiling:     4.6.0-20160607 // not running:  4.5.0a Step 2: create POJO and a suitable BIRT DataSource for the Designer: http://yaragalla.blogspot.de/2013/10/using-pojo-datasource-in-birt-43.html DataSource really needs the open, next and close Methods build as jar, needed as such in BIRT Designer Step 3: use BIRT runtime in your Spring Boot Controller: InputStream reportDesign = getClass(). ...
Mehr anzeigen

Debugging angular 4 Jasmin/Karma tests with Visual Studio Code

Bild
remember how to debug with visual studio code an angular cli generated jasmin test. Change the config: add to visual studio code launch.config ... { "type" : "chrome" , "request" : "attach" , "name" : "Attach to karma test runner" , "sourceMaps" : true , "port" : 9333 , "webRoot" : "${workspaceRoot}" , "sourceMapPathOverrides" : { "webpack:///*" : "${workspaceRoot}/*" } }, add to karma conf.js ... singleRun: false , browsers: [ 'ChromeDebugging' ], customLaunchers: { ChromeDebugging: { base: 'Chrome' , flags: [ '--remote-debugging-port=9333' ] } }, Start the debugging session: ng test set some breakpoints in visual studio code start " Attach to Karma Tests " in Visual Studio Code refre...
Mehr anzeigen