{"id":568,"date":"2005-01-05T23:32:41","date_gmt":"2005-01-05T21:32:41","guid":{"rendered":"http:\/\/10.0.0.2\/wordpress\/?p=568"},"modified":"2016-01-30T01:38:34","modified_gmt":"2016-01-30T00:38:34","slug":"i_did_it_ironpython_reads_oracle_10g","status":"publish","type":"post","link":"https:\/\/www.switchbl8.nl\/blog\/2005\/01\/i_did_it_ironpython_reads_oracle_10g\/","title":{"rendered":"I did it: IronPython reads Oracle 10g!"},"content":{"rendered":"<p>Not too big a accomplishment for the experienced .NET-programmer, but since I&#8217;m still learning .NET, and ODP.NET and IronPython, I think I did something great. This is the script (don&#8217;t be scared):<\/p>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\nimport sys\r\nsys.LoadAssemblyByName('Oracle.DataAccess')\r\nfrom Oracle.DataAccess import *\r\nfrom Oracle.DataAccess.Client import *\r\nOraCon = OracleConnection()\r\nOraCon.ConnectionString = 'User Id=scott; Password=tiger; Data Source=ORCL'\r\nOraCon.Open()\r\nOraCmd = OraCon.CreateCommand()\r\nOraCmd.CommandText = 'select ename from emp where deptno = 20'\r\nOraDR = OraCmd.ExecuteReader()\r\nwhile OraDR.Read(): \r\n    print(&quot;Employee Name: &quot; + OraDR.GetString(0))\r\nOraCon.Close()\r\n\r\n<\/pre>\n<p>And this is the output:<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Not too big a accomplishment for the experienced .NET-programmer, but since I&#8217;m still learning .NET, and ODP.NET and IronPython, I think I did something great. This is the script (don&#8217;t be scared): import sys sys.LoadAssemblyByName(&#8216;Oracle.DataAccess&#8217;) from Oracle.DataAccess import * from Oracle.DataAccess.Client import * OraCon = OracleConnection() OraCon.ConnectionString = &#8216;User Id=scott; Password=tiger; Data Source=ORCL&#8217; OraCon.Open() OraCmd <a href='https:\/\/www.switchbl8.nl\/blog\/2005\/01\/i_did_it_ironpython_reads_oracle_10g\/' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34,19,25],"tags":[],"class_list":["post-568","post","type-post","status-publish","format-standard","hentry","category-net","category-oracle","category-python","category-34-id","category-19-id","category-25-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"_links":{"self":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/comments?post=568"}],"version-history":[{"count":3,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/568\/revisions"}],"predecessor-version":[{"id":1813,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/568\/revisions\/1813"}],"wp:attachment":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/media?parent=568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/categories?post=568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/tags?post=568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}