Hand-Aurora-日志级别

开发程序包时日志

-- 调用
hand_debug_pkg.log(p_message => '各种日志记录.....bilibili.....');

-- 查看
select * from debug_log where pkg_name like '%包的名字%' and trunc(creation_date ) = trunc(sysdate);
select * from debug_log where  creation_date  > sysdate - 1/24/60

正式环境日志

--1.0 业务系统请求记录
select * from sys_runtime_request_record where session_id = 81590 order by enter_time desc;

--2.0 操作明细
select * from sys_runtime_request_detail order by enter_time desc;

--3.0 异常日志
select * from sys_runtime_exception_log where session_id = 81590 order by creation_time desc;

项目目录结构

如果是重写的查询方法,在
/log 

如果是正常的BM文件
/log/module/功能号

如果是动态页面
/log/layout/动态页面

查询系统抛出的异常
select * from sys_raise_app_errors order by 1  desc;

日志明细
select * from sys_runtime_exception_log order by 1  desc;