create table
-- Create table
create table t_cem_proc_logs
(
id varchar2(32),
proc_mc varchar2(100),
title varchar2(4000),
content clob,
log_type varchar2(10),
log_time date default sysdate
)
;
-- Add comments to the table
comment on table t_cem_proc_logs
is '\u65e5\u5fd7';
-- Add comments to the columns
comment on column t_cem_proc_logs.id
is 'id';
comment on column t_cem_proc_logs.proc_mc
is '\u8fc7\u7a0b\u540d';
comment on column t_cem_proc_logs.title
is '\u6807\u9898';
comment on column t_cem_proc_logs.content
is '\u5185\u5bb9';
comment on column t_cem_proc_logs.log_type
is '\u65e5\u5fd7\u7ea7\u522b\uff1ainfo,error,debug';
comment on column t_cem_proc_logs.log_time
is '\u65f6\u95f4';
-- Create\/Recreate primary, unique and foreign key constraints
alter table t_cem_proc_logs
add constraint pri_proc_logs primary key (ID);<\/p>
-- Create table
create table T_CEM_TASK_LOG
(
id VARCHAR2(32) not null,
task_id VARCHAR2(100),
task_code VARCHAR2(100),
start_date DATE,
end_date DATE,
log_status VARCHAR2(2),
log_message VARCHAR2(4000),
createdate DATE,
requestdata CLOB,
responsedata CLOB,
modifytime DATE,
corpid VARCHAR2(32)
);
-- Add comments to the table
comment on table T_CEM_TASK_LOG
is '\u8c03\u5ea6\u65e5\u5fd7';
-- Add comments to the columns
comment on column T_CEM_TASK_LOG.id
is 'ID';
comment on column T_CEM_TASK_LOG.task_id
is '\u8c03\u5ea6\u6807\u8bc6';
comment on column T_CEM_TASK_LOG.task_code
is '\u8c03\u5ea6\u4efb\u52a1\u4ee3\u7801';
comment on column T_CEM_TASK_LOG.start_date
is '\u5f00\u59cb\u6267\u884c\u65f6\u95f4';
comment on column T_CEM_TASK_LOG.end_date
is '\u6267\u884c\u7ed3\u675f\u65f6\u95f4';
comment on column T_CEM_TASK_LOG.log_status
is '\u72b6\u6001 0\uff1a\u6267\u884c\u4e2d 1\uff1a\u6267\u884c\u5b8c\u6210 2\uff1a\u6267\u884c\u9519\u8bef';
comment on column T_CEM_TASK_LOG.log_message
is '\u65e5\u5fd7\u4fe1\u606f';
comment on column T_CEM_TASK_LOG.createdate
is '\u521b\u5efa\u65e5\u671f';
comment on column T_CEM_TASK_LOG.requestdata
is '\u8bf7\u6c42\u62a5\u6587';
comment on column T_CEM_TASK_LOG.responsedata
is '\u8fd4\u56de\u62a5\u6587';
comment on column T_CEM_TASK_LOG.modifytime
is '\u4fee\u6539\u65f6\u95f4';
comment on column T_CEM_TASK_LOG.corpid
is '\u4f01\u4e1aid';
-- Create\/Recreate indexes
create index T_CEM_TASK_LOG_N1 on T_CEM_TASK_LOG (TASK_ID);
-- Create\/Recreate primary, unique and foreign key constraints
alter table T_CEM_TASK_LOG
add constraint T_CEM_TASK_LOG_PK primary key (ID);<\/p>
<\/p>
<\/p>
Create sequence
-- Create sequence
create sequence seq_log
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 20
cycle;<\/p>
package
CREATE OR REPLACE PACKAGE LOGUTILS IS<\/p>
-- Author : DYB
-- Created : 2017\/3\/28 10:34:51
-- Purpose : \u65e5\u5fd7\u8bb0\u5f55\u5de5\u5177\u7c7b<\/p>
--\u65e5\u5fd7
PROCEDURE LOG(P_TASK_ID VARCHAR2,
P_TASK_CODE VARCHAR2,
P_START_DATE DATE DEFAULT NULL,
P_END_DATE DATE DEFAULT NULL,
P_LOG_STATUS VARCHAR2 DEFAULT NULL,
P_LOG_MESSAGE VARCHAR2 DEFAULT NULL);
PROCEDURE INFO(p_proc_name varchar2, title varchar2, content clob);
PROCEDURE DEBUG(p_proc_name varchar2, title varchar2, content clob);
&nbs","orderid":"0","title":"Oracle\u5b58\u50a8\u8fc7\u7a0b\u5b9e\u73b0\u8bb0\u5f55\u65e5\u5fd7(\u4e00)","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"302","pages":"2","comments":"0","posttime":"2023-07-26 08:18:10","list":"1690330690","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"Oracle<\/A> \u50a8\u8fc7\u7a0b<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"119.59.235.169","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"Oracle\u5b58\u50a8\u8fc7\u7a0b\u5b9e\u73b0\u8bb0\u5f55\u65e5\u5fd7","lastview":"1714238148","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}