{"id":18616,"date":"2026-05-27T10:28:50","date_gmt":"2026-05-27T02:28:50","guid":{"rendered":"https:\/\/kbwp.transwarp.cn\/?p=18616"},"modified":"2026-05-27T10:29:40","modified_gmt":"2026-05-27T02:29:40","slug":"kundb%e4%bd%bf%e7%94%a8dbms_utility-format_error_backtrace%e8%ae%b0%e5%bd%95%e6%8a%a5%e9%94%99%e8%a1%8c%e5%8f%b7","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=18616","title":{"rendered":"kundb\u4f7f\u7528DBMS_UTILITY.FORMAT_ERROR_BACKTRACE\u8bb0\u5f55\u62a5\u9519\u884c\u53f7"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<hr \/>\n<p><code>DBMS_UTILITY.FORMAT_ERROR_BACKTRACE<\/code> \u662f Kundb \u63d0\u4f9b\u7684\u4e00\u4e2a\u5185\u7f6e\u51fd\u6570\uff0c\u7528\u4e8e<strong>\u83b7\u53d6\u5f02\u5e38\u53d1\u751f\u65f6\u7684\u5b8c\u6574\u8c03\u7528\u5806\u6808\u56de\u6eaf\u4fe1\u606f<\/strong>\u3002\u5b83\u8fd4\u56de\u4e00\u4e2a\u683c\u5f0f\u5316\u7684\u5b57\u7b26\u4e32\uff0c\u7cbe\u786e\u6307\u51fa\u54ea\u4e00\u884c\u4ee3\u7801\u629b\u51fa\u4e86\u5f02\u5e38\u2014\u2014\u8fd9\u662f <code>SQLERRM<\/code> \u548c <code>SQLCODE<\/code> \u65e0\u6cd5\u63d0\u4f9b\u7684\u3002<\/p>\n<h3>\u8be6\u7ec6\u4ecb\u7ecd<\/h3>\n<hr \/>\n<h4>1.\u57fa\u7840\u5355\u5b58\u50a8\u8fc7\u7a0b\uff08\u6355\u83b7\u884c\u53f7\uff09<\/h4>\n<p>\u6545\u610f\u5236\u9020\u8bed\u6cd5 \/ \u8fd0\u884c\u65f6\u5f02\u5e38\uff0c\u6355\u83b7\u5e76\u6253\u5370\u3001\u5165\u5e93\u5806\u6808\u4fe1\u606f\u3002<\/p>\n<pre><code class=\"language-sql\">delimiter \/\/\nCREATE OR REPLACE PROCEDURE test_backtrace AS\n  v_num int;\nBEGIN\n    v_num :=1;\n    v_num := 1\/0;\nEXCEPTION\n  WHEN OTHERS THEN\n    DBMS_OUTPUT.PUT_LINE('===== \u9519\u8bef\u56de\u6eaf\u4fe1\u606f =====');\n    DBMS_OUTPUT.PUT_LINE(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);\nEND;\n\/\/\n\ncall test_backtrace\ncall dbms_output.enable(2000);\nselect * from table(dbms_output.get_lines_func(20000));<\/code><\/pre>\n<p>\u62a5\u9519\u663e\u793a\u7b2c5\u884c\u51fa\u9519<\/p>\n<div style=\"box-shadow: 1px 1px 10px rgba(0,0,0,0.1); padding: 1px; display: inline-block; width: auto; margin-bottom: 10px;\">\n  <img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/05\/image-1779848716004.png\" style=\"display: block;\">\n<\/div>\n<h4>2.\u5d4c\u5957\u8c03\u7528\uff08\u591a\u5c42\u8fc7\u7a0b\uff0c\u5b8c\u6574\u8c03\u7528\u6808\uff09<\/h4>\n<p>\u5b9e\u9645\u5f00\u53d1\u5e38\u7528\uff1aA \u8c03\u7528 B\uff0cB \u5185\u90e8\u62a5\u9519\uff0c\u5806\u6808\u4f1a\u5c55\u793a\u5168\u94fe\u8def\u8c03\u7528\u5173\u7cfb + \u6bcf\u4e00\u5c42\u884c\u53f7\u3002<\/p>\n<p><strong>\u521b\u5efa\u5f02\u5e38\u65e5\u5fd7\u8868\uff08\u7528\u4e8e\u843d\u5730\u62a5\u9519\u4fe1\u606f\uff09<\/strong><\/p>\n<pre><code class=\"language-sql\">CREATE TABLE proc_error_log (\n    id          NUMBER      ,\n    proc_name   VARCHAR2(200),  -- \u51fa\u9519\u8fc7\u7a0b\/\u51fd\u6570\u540d\n    error_code  NUMBER,         -- \u9519\u8bef\u7801\n    error_msg   VARCHAR2(4000), -- \u9519\u8bef\u4fe1\u606f\n    error_stack CLOB,           -- \u62a5\u9519\u884c\u53f7+\u5806\u6808\n    create_time TIMESTAMP DEFAULT SYSTIMESTAMP\n);<\/code><\/pre>\n<p><strong>\u5185\u5c42\u5b58\u50a8\u8fc7\u7a0b\uff08\u51fa\u9519\u70b9\uff09<\/strong><\/p>\n<pre><code class=\"language-sql\">delimiter \/\/\nCREATE OR REPLACE PROCEDURE sp_inner\nAS\nBEGIN\n    -- \u6545\u610f\u62a5\u9519\uff1a\u9664\u6570\u4e3a0\n    DECLARE\n        v_num NUMBER;\n    BEGIN\n        v_num := 10 \/ 0;\n    END;\nEND;\n\/\/<\/code><\/pre>\n<p><strong>\u5916\u5c42\u5b58\u50a8\u8fc7\u7a0b\uff08\u8c03\u7528\u5185\u5c42 + \u7edf\u4e00\u6355\u83b7\u5f02\u5e38\uff09<\/strong><\/p>\n<pre><code class=\"language-sql\">delimiter \/\/\nCREATE OR REPLACE PROCEDURE sp_outer\nAS\nBEGIN\n    DBMS_OUTPUT.PUT_LINE('\u5f00\u59cb\u6267\u884c\u5916\u5c42\u8fc7\u7a0b');\n\n    -- \u8c03\u7528\u5185\u5c42\u8fc7\u7a0b\n    sp_inner;\n\nEXCEPTION\n    WHEN OTHERS THEN\n        DBMS_OUTPUT.PUT_LINE('=== \u5b8c\u6574\u5f02\u5e38\u5806\u6808 ===');\n        DBMS_OUTPUT.PUT_LINE(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);\n\n        -- \u5165\u5e93\u65e5\u5fd7\n        INSERT INTO proc_error_log(proc_name, error_code, error_msg, error_stack)\n        VALUES(\n            'sp_outer',\n            SQLCODE,\n            SQLERRM,\n            DBMS_UTILITY.FORMAT_ERROR_BACKTRACE\n        );\n        COMMIT;\nEND;\n\/\/<\/code><\/pre>\n<p><strong>\u6267\u884c<\/strong><\/p>\n<pre><code class=\"language-sql\">call sp_outer;\nselect * from proc_error_log<\/code><\/pre>\n<p>\u5806\u6808\u8f93\u51fa\u793a\u4f8b\uff08\u5b8c\u6574\u8c03\u7528\u94fe\uff09\uff1a<\/p>\n<pre><code class=\"language-sql\">at \"lkw.sp_inner\", line 8\nat \"lkw.sp_outer\", line 7\nat anonymous block, line 1<\/code><\/pre>\n<p>\u4ece\u4e0a\u5230\u4e0b\uff1a<\/p>\n<ul>\n<li>\u6700\u5148\u62a5\u9519\uff1asp_inner \u7b2c 8 \u884c<\/li>\n<li>\u5916\u5c42\u8c03\u7528\u4f4d\u7f6e\uff1asp_outer \u7b2c 7 \u884c<\/li>\n<\/ul>\n<p>\u6392\u67e5\u591a\u5c42\u5d4c\u5957\u4ee3\u7801\u975e\u5e38\u9ad8\u6548\u3002<\/p>\n<div style=\"box-shadow: 1px 1px 10px rgba(0,0,0,0.1); padding: 1px; display: inline-block; width: auto; margin-bottom: 10px;\">\n  <img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/05\/image-1779848896215.png\" style=\"display: block;\">\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 DBMS_UTILITY.FORMAT_ERROR_BACKTRACE \u662f Kundb \u63d0\u4f9b\u7684\u4e00\u4e2a\u5185 ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=18616\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-18616","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/18616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18616"}],"version-history":[{"count":2,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/18616\/revisions"}],"predecessor-version":[{"id":18620,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/18616\/revisions\/18620"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}