Grrr\u2026 Oracle Data Provider for .NET just cost me time, (some) money and above all reputation.<\/p>\n
My .NET application was using MS Oracle Data Provider which was OK. Many are not satisfied with it, but I had no particular problems\u2026 Until I hit BLOBs.<\/p>\n
To be honest BLOBs are not often used in business application, so I didn’t have much knowledge on how to use it in c#. It is quite easy, but MS Oracle data provider is not fond of them.<\/p>\n
So I was forced to use ORACLE Data provider for .NET\u2026 And \u2013 o my god \u2013 database is full of NUMBER fields so MS is using OracleType.Number<\/strong>, but Oracle for .NET does not know \u201cnumbers\u201d so I was forced to change the source code from OracleType.Number to OracleDbType.Int32 or OracleDbType.Double <\/strong>(or something like that).<\/p>\n And there I made a typical programming error \u2013 typo \u2013 I one procedure I changed OracleType.Number to OracleDbType.Int32, but it was used as amount field (so double)\u2026 <\/em>\ud83d\ude41<\/p>\n And all \u201cof the sudden\u201d amounts were rounded to integers. Nobody noticed for 14 days\u2026 and then panic \u2013 everything is wrong \u2013 who is to blame \u2013 me \u2013 I admit (ashamed)…<\/p>\n BUT: Thanks Oracle, maybe guys from DB team can teach guys from .NET team what are “numbers” in DB terms…<\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" Grrr\u2026 Oracle Data Provider for .NET just cost me time, (some) money and above all reputation. My .NET application was using MS Oracle Data Provider which was OK. Many are not satisfied with it, but I had no particular problems\u2026 Until I hit BLOBs. To be honest BLOBs are not often used in business application, … Continue reading Oracle Data Provider For .NET – What is Number?<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35,53,19],"tags":[54,66],"_links":{"self":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/1369"}],"collection":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/comments?post=1369"}],"version-history":[{"count":4,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/1369\/revisions"}],"predecessor-version":[{"id":1373,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/1369\/revisions\/1373"}],"wp:attachment":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/media?parent=1369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/categories?post=1369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/tags?post=1369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}