{"id":75,"date":"2014-01-17T01:44:00","date_gmt":"2014-01-16T16:44:00","guid":{"rendered":"https:\/\/www.picolix.jp\/blog\/2014\/01\/ocibindbynamebindnullphp-449-oci8.html\/"},"modified":"2019-04-02T10:27:01","modified_gmt":"2019-04-02T01:27:01","slug":"ocibindbynamebindnullphp-449-oci8","status":"publish","type":"post","link":"https:\/\/www.picolix.jp\/blog\/2014\/01\/ocibindbynamebindnullphp-449-oci8.html","title":{"rendered":"[\u30e1\u30e2] oci_bind_by_name\u3067\u306ebind\u3059\u308b\u5024\u304cNULL\u6642\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56\u3002PHP 4.4.9 \/ oci8 Revision: 1.273 \/ Oracle Version  10.1"},"content":{"rendered":"<p>PHP Version 4.4.9 \/ oci8 Revision: 1.273 \/ Oracle Version &nbsp;10.1<br \/>\n\u3067 oci_bind_by_name($stmt, &#8216;:dummy&#8217;, $dummy);<br \/>\n$dummy \u304c NULL\u306e\u6642\u3001oci_bind_by_name\u306f\u306a\u305c\u304b\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u30a8\u30e9\u30fc\u5185\u5bb9\uff1a<br \/>\nAllowed memory size of 8388608 bytes exhausted (tried to allocate -153092211 bytes)<\/p>\n<p>\u30b0\u30b0\u3063\u3066\u3082\u5bfe\u7b56\u65b9\u6cd5\u304c\u51fa\u3066\u6765\u306a\u3044\u306e\u3067\u30c8\u30e9\u30a4\uff06\u30a8\u30e9\u30fc\u3067\u5bfe\u5fdc\u3002<\/p>\n<p>$dummy = &#8220;&#8221;;<br \/>\n$dummy = null;<br \/>\n\u3069\u308c\u3082\u3060\u3081\u3067\u3001\u4ee5\u4e0b\u306b\u3059\u308b\u3068OK<\/p>\n<p>$dummy .= &#8220;&#8221;;<br \/>\n\u7a7a\u6587\u5b57\u3092\u9023\u7d50\u3059\u308b\u3068\u306a\u305c\u304bOK\u3068\u306a\u308b\u3002\u591a\u5206\u5909\u6570$dummy\u306e\u30e1\u30e2\u30ea\u30fc\u4e0a\u306b<br \/>\n\u4f55\u304b\u304c\u30bb\u30c3\u30c8\u3055\u308c\u3066\u3001oci_bind_by_name\u306e\u65b9\u3067\u6b63\u3057\u304fNULL\u304c\u8a8d\u8b58\u3055\u308c\u305f\uff01\uff1f<\/p>\n<p>\n$sql = &#8220;select sysdate from dual where sysdate &gt; :dummy&#8221;;<br \/>\nif($dummy == &#8220;&#8221;){<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dummy .= &#8220;&#8221;;<br \/>\n}<br \/>\n$stmt = oci_parse($Conn,$sql);<br \/>\noci_bind_by_name($stmt, &#8216;:dummy&#8217;, $dummy);<\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PHP Version 4.4.9 \/ oci8 Revision: 1.273 \/ Oracle Version &nbsp;10.1 \u3067 oci_bind_by_name($stmt, &#8216;:dummy&#038;# &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.picolix.jp\/blog\/2014\/01\/ocibindbynamebindnullphp-449-oci8.html\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;[\u30e1\u30e2] oci_bind_by_name\u3067\u306ebind\u3059\u308b\u5024\u304cNULL\u6642\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56\u3002PHP 4.4.9 \/ oci8 Revision: 1.273 \/ Oracle Version  10.1&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[6],"_links":{"self":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/75"}],"collection":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/comments?post=75"}],"version-history":[{"count":1,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":1337,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions\/1337"}],"wp:attachment":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/media?parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/categories?post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/tags?post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}