Wednesday, 8 March 2017

[Oracle] How to show trigger or procedure error log (트리거 또는 프로시져 에러 로그 확인 방법)

-- Current user error log
SELECT * FROM SYS.USER_ERRORS;
-- Current user error log related with trigger
SELECT * FROM SYS.USER_ERRORS WHERE TYPE ='TRIGGER';
-- Current user error log related with procedure
SELECT * FROM SYS.USER_ERRORS WHERE TYPE ='PROCEDURE';

-- All user error log
SELECT * FROM SYS.DBA_ERRORS;
-- All user error log related with trigger
SELECT * FROM SYS.DBA_ERRORS WHERE TYPE ='TRIGGER';
-- All user error log related with procedure
SELECT * FROM SYS.DBA_ERRORS WHERE TYPE ='PROCEDURE';





 

No comments:

Post a Comment