-- 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