{"id":312,"date":"2015-12-18T16:18:26","date_gmt":"2015-12-18T08:18:26","guid":{"rendered":"http:\/\/www.lisq.net.cn\/?p=312"},"modified":"2018-09-13T15:15:48","modified_gmt":"2018-09-13T07:15:48","slug":"%e5%85%b3%e4%ba%8e%e4%bf%9d%e5%ad%98%e9%94%99%e8%af%af%e7%9a%84%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b","status":"publish","type":"post","link":"https:\/\/www.lisq.net\/?p=312","title":{"rendered":"\u5173\u4e8e\u4fdd\u5b58\u9519\u8bef\u7684\u5b58\u50a8\u8fc7\u7a0b"},"content":{"rendered":"<p>Create table \u5b58\u653e\u9519\u8bef\u4fe1\u606f<\/p>\n<pre class=\"lang:plsql decode:true\">create table BI_ERROR_RECORD\r\n(\r\nerror_id NUMBER(16) not null,\r\nerror_code NUMBER(10),\r\nerror_msg VARCHAR2(2000 BYTE),\r\nerror_date DATE,\r\nerror_program VARCHAR2(200 BYTE)\r\n);\r\ncreate sequence SEQ_BI_ERROR_RECORD\r\nminvalue 1\r\nmaxvalue 9999999999999999\r\nstart with 1\r\nincrement by 1\r\ncache 20;<\/pre>\n<p>\u5b58\u50a8\u8fc7\u7a0b<\/p>\n<pre class=\"lang:plsql decode:true \">CREATE OR REPLACE PROCEDURE SAVE_ERROR_INFO(IN_SQLCODE BI_ERROR_RECORD.ERROR_CODE%TYPE,\r\nIN_MSG BI_ERROR_RECORD.ERROR_MSG%TYPE,\r\nIN_PROGRAM BI_ERROR_RECORD.ERROR_PROGRAM%TYPE) AS\r\nBEGIN<\/pre>\n<p>&#8211;\u4fdd\u5b58\u9519\u8bef\u4fe1\u606f<\/p>\n<pre class=\"lang:plsql decode:true \">INSERT INTO BI_ERROR_RECORD\r\n(ERROR_ID, ERROR_CODE, ERROR_MSG, ERROR_DATE, ERROR_PROGRAM)\r\nVALUES\r\n(SEQ_BI_ERROR_RECORD.NEXTVAL, IN_SQLCODE, IN_MSG, SYSDATE, IN_PROGRAM);\r\nEND SAVE_ERROR_INFO;<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create table \u5b58\u653e\u9519\u8bef\u4fe1\u606f create tab &hellip;<\/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":false,"_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":[2],"tags":[],"class_list":["post-312","post","type-post","status-publish","format-standard","hentry","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7zRbQ-52","_links":{"self":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/312","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=312"}],"version-history":[{"count":6,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions"}],"predecessor-version":[{"id":364,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions\/364"}],"wp:attachment":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}