\u8fd1\u671f\u5728\u770bPL\/SQL\u7684\u6587\u6863\uff0c\u53d1\u73b0\u4e86\u5f88\u591a\u6709\u8da3\u7684\u5c0f\u77e5\u8bc6\u70b9\uff0c\u6709\u7684\u4ee5\u524d\u77e5\u9053\uff0c\u4e5f\u6709\u5f88\u591a\u4ee5\u524d\u5e76\u4e0d\u4e86\u89e3\u7684\uff0c\u5199\u51fa\u6765\u548c\u5927\u5bb6\u5206\u4eab\u4e00\u4e0b\u3002
\n\u8fd9\u7bc7\u63cf\u8ff0\u5f02\u5e38\u6355\u83b7\u7684\u4f5c\u7528\u8303\u56f4\u3002
\nPL\/SQL\u7684\u5f02\u5e38\u6355\u83b7\u53ea\u9488\u5bf9\u6267\u884c\u90e8\u5206\uff0c\u5728\u58f0\u660e\u90e8\u5206\u4ea7\u751f\u7684\u5f02\u5e38\u662f\u65e0\u6cd5\u6355\u83b7\u7684\uff1a<\/p>\n
SQL> set serverout on size 100000\r\nSQL> declare\r\n2 v_num number;\r\n3 begin\r\n4 v_num := 'a';\r\n5 exception\r\n6 when others then\r\n7 dbms_output.put_line('Exception captured!');\r\n8 end;\r\n9 \/\r\nException captured!\r\nPL\/SQL procedure successfully completed.\r\nSQL> declare\r\n2 v_num number := 'a';\r\n3 begin\r\n4 null;\r\n5 exception\r\n6 when others then\r\n7 dbms_output.put_line('Exception captured!');\r\n8 end;\r\n9 \/\r\ndeclare\r\n*\r\nERROR at line 1:\r\nORA-06502: PL\/SQL: numeric or value error: character to number conversion error\r\nORA-06512: at line 2<\/pre>\n\u60f3\u8981\u89e3\u51b3\u58f0\u660e\u90e8\u5206\u7684\u5f02\u5e38\u6355\u83b7\uff0c\u89e3\u51b3\u65b9\u6cd5\u662f\u5728\u5916\u9762\u5d4c\u5957\u4e00\u5c42\uff0c\u5728\u5916\u5c42\u8fdb\u884c\u5f02\u5e38\u7684\u6355\u83b7\uff1a<\/p>\n
SQL> begin\r\n2 declare\r\n3 v_num number := 'a';\r\n4 begin\r\n5 null;\r\n6 exception\r\n7 when others then\r\n8 dbms_output.put_line('Exception captured!');\r\n9 end;\r\n10 exception\r\n11 when others then\r\n12 dbms_output.put_line('Outer exception captured!');\r\n13 end;\r\n14 \/\r\nOuter exception captured!\r\nPL\/SQL procedure successfully completed.<\/pre>\n\u9664\u4e86\u58f0\u660e\u90e8\u5206\uff0c\u5f02\u5e38\u5904\u7406\u90e8\u5206\u672c\u8eab\u5bfc\u81f4\u7684\u5f02\u5e38\u540c\u6837\u4e5f\u662f\u65e0\u6cd5\u6355\u83b7\u7684\uff0c\u89e3\u51b3\u65b9\u6cd5\u548c\u58f0\u660e\u90e8\u5206\u4e00\u6837\uff0c\u9700\u8981\u5728\u5916\u5c42\u8fdb\u884c\u6355\u83b7\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u8fd1\u671f\u5728\u770bPL\/SQL\u7684\u6587\u6863\uff0c\u53d1\u73b0\u4e86\u5f88\u591a\u6709\u8da3\u7684\u5c0f\u77e5\u8bc6\u70b9\uff0c\u6709\u7684\u4ee5\u524d\u77e5\u9053\uff0c\u4e5f\u6709\u5f88\u591a\u4ee5\u524d\u5e76\u4e0d\u4e86\u89e3\u7684\uff0c\u5199\u51fa\u6765\u548c\u5927\u5bb6\u5206\u4eab\u4e00\u4e0b\u3002 \u8fd9\u7bc7\u63cf\u8ff0\u5f02\u5e38\u6355\u83b7\u7684\u4f5c\u7528\u8303\u56f4\u3002 PL\/SQL\u7684\u5f02\u5e38\u6355\u83b7\u53ea\u9488\u5bf9\u6267\u884c\u90e8\u5206\uff0c\u5728\u58f0\u660e\u90e8\u5206\u4ea7\u751f\u7684\u5f02\u5e38\u662f\u65e0\u6cd5\u6355\u83b7\u7684\uff1a SQL> set serverout on size 100000 SQL> declare 2 v_num number; 3 begin 4 v_num := ‘a’; 5 exception 6 when others then 7 dbms_output.put_line(‘Exception captured!’); 8 end; 9 \/ Exception captured! PL\/SQL procedure successfully completed. SQL> … Continue reading