{"id":235,"date":"2017-01-09T18:05:32","date_gmt":"2017-01-09T10:05:32","guid":{"rendered":"http:\/\/www.lisq.net.cn\/?p=235"},"modified":"2017-02-03T16:48:39","modified_gmt":"2017-02-03T08:48:39","slug":"ora-03137-ttc-%e5%8d%8f%e8%ae%ae%e5%86%85%e9%83%a8%e9%94%99%e8%af%af-12333","status":"publish","type":"post","link":"https:\/\/www.lisq.net\/?p=235","title":{"rendered":"ORA-03137: TTC \u534f\u8bae\u5185\u90e8\u9519\u8bef: [12333]"},"content":{"rendered":"

Bug 10075392\u00a0\u00a0ORA-3137 [12333] or bind variable interpreted as NULL using SQL with binds<\/u><\/h3>\n

This note gives a brief overview of bug 10075392.
\nThe content was last updated on: 28-JUN-2013
\nClick\u00a0<\/em>here<\/em><\/a>\u00a0<\/em>for details of each of the sections below.<\/em><\/p>\n

Affects:<\/u><\/h3>\n\n\n\n\n\n\n
Product (Component<\/em>)<\/strong><\/td>\nOracle Server (Rdbms)<\/td>\n<\/tr>\n
Range of versions\u00a0believed<\/em>\u00a0to be affected<\/strong><\/td>\nVersions BELOW 12.1<\/td>\n<\/tr>\n
Versions\u00a0confirmed<\/em>\u00a0as being affected<\/strong><\/td>\n\n
Platforms affected<\/strong><\/td>\nGeneric (all \/ most platforms affected)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Fixed:<\/u><\/h3>\n\n\n\n\n\n\n
This issue is fixed in<\/strong><\/td>\n\n
\n

Symptoms:<\/u><\/h3>\n<\/td>\n

\n

Related To:<\/u><\/h3>\n<\/td>\n<\/tr>\n

\n\n
    \n
  • (None Specified)<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Description<\/u><\/h3>\n

A SQL statement using bind variables may get an ORA-3137 [12333] error,\u00a0 or may incorrectly treat the bind as NULL . Rediscovery Notes: If you see ORA-3137:[1233] or bind value is null, you might be seeing this problem Workaround<\/u><\/strong> None<\/p>\n

\u5bf9trace\u6587\u4ef6\u4e2d\u63d0\u5230\u7684SQL\u8fdb\u884c\u5206\u6790\uff0c\u5728DBA_HIST_SQLBIND\u4e2d\u627e\u5230\u4e3aNULL\u7684\u7ed1\u5b9a\u53d8\u91cf<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Bug 10075392\u00a0\u00a0ORA-3137 [12333] …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[8],"tags":[12],"class_list":["post-235","post","type-post","status-publish","format-standard","hentry","category-8","tag-bug"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7zRbQ-3N","_links":{"self":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=235"}],"version-history":[{"count":2,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions"}],"predecessor-version":[{"id":239,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions\/239"}],"wp:attachment":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}