{"id":1150,"date":"2018-09-05T20:11:37","date_gmt":"2018-09-05T19:11:37","guid":{"rendered":"http:\/\/piatkosia.k4be.pl\/wordpress\/?p=1150"},"modified":"2019-04-20T14:30:26","modified_gmt":"2019-04-20T13:30:26","slug":"bitwa-pod-oraclem","status":"publish","type":"post","link":"https:\/\/piatkosia.k4be.pl\/wordpress\/2018\/09\/05\/bitwa-pod-oraclem\/","title":{"rendered":"Bitwa pod Oraclem"},"content":{"rendered":"<p style=\"text-align: justify;\">Kolejna notka z pola bitwy pod Oraclem. Znowu b\u0142\u0105d z cyklu &#8222;pod MS SQLem dzia\u0142a&#8221;.<\/p>\n<pre style=\"text-align: justify;\">ORA-06502: PL\/SQL: b\u0142\u0105d liczby lub warto\u015bci: za ma\u0142y bufor tekstowy\n<!--more--><\/pre>\n<p style=\"text-align: justify;\">Co to qr2 ma by\u0107! Debug, pauza, immed, sesyjka.Parameters kopia do notatnika, wycinanie value i przeklejenie do debuga w Oracle Developer, przesz\u0142o, stworzy\u0142o, parametry poprawne, herba, fejsik, za\u0142amka, kopia do googla, brak rozwi\u0105za\u0144&#8230; mo\u017ce uprawnienia? Wycieczka do wc, przecie\u017c gdyby nie by\u0142o uprawnienia to by si\u0119 nie wywo\u0142a\u0142o- b\u0142\u0105d by\u0142by inny, herbatka, za\u0142amka, irc, skype &#8211; mo\u017ce kto\u015b ogarnie, \u015blepa uliczka. Ok, to diffy z prehistori\u0105 bo kiedy\u015b to ju\u017c dzia\u0142a\u0142o.<\/p>\n<p style=\"text-align: justify;\">&#8230;okaza\u0142o si\u0119 \u017ce z\u0142y DBType dla parametru dla procki dosta\u0142, MS Sql si\u0119 przy tym samym kodzie nie zaj\u0105kn\u0105\u0142, wi\u0119c najwyra\u017aniej nhibernate zmapowa\u0142 DbType.StringFixedLength i DbType.String do tego samego typu.<\/p>\n<p style=\"text-align: justify;\">P\u00f3\u0142 dnia w plecy a pierd\u00f3\u0142ka na 1 linijk\u0119 by zachowa\u0107 kompatybilno\u015b\u0107 z badziewiem<\/p>\n<p style=\"text-align: justify;\">Chyba zaczynam to lubie\u0107.<\/p>\n<p style=\"text-align: justify;\">Podsumowuj\u0105c: sprawd\u017a czy typ parametru (DbType) jest aby na pewno poprawny, a nie tylko podobny (lub skopiowany z innego miejsca;) ).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kolejna notka z pola bitwy pod Oraclem. Znowu b\u0142\u0105d z cyklu &#8222;pod MS SQLem dzia\u0142a&#8221;. ORA-06502: PL\/SQL: b\u0142\u0105d liczby lub warto\u015bci: za ma\u0142y bufor tekstowy<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[609,645,54,607],"tags":[617,619,615,611,613],"class_list":["post-1150","post","type-post","status-publish","format-standard","hentry","category-bazki","category-gmtl","category-ms","category-nhibernate","tag-dbtype","tag-gmtl","tag-ms-sql","tag-nhibermate","tag-oracle","entry"],"_links":{"self":[{"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/posts\/1150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/comments?post=1150"}],"version-history":[{"count":1,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/posts\/1150\/revisions"}],"predecessor-version":[{"id":1151,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/posts\/1150\/revisions\/1151"}],"wp:attachment":[{"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/media?parent=1150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/categories?post=1150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/tags?post=1150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}