• Home
  • Space
  • More options

MJB a PL/SQL - traces Framework

PLSQL framework for tracing and logging of various outputs. It works for internal Oracle objects and third party programs. it track logs from many platforms in database

Main points:

  • Easy and simple implementation.
  • Possibility to track using tickets.
  • Possibility to track subroutines.

Examples

Log levels:

Begin
    OLOG.info  ('mess info ');
    OLOG.warn  ('mess warn ');
    OLOG.error ('mess error');
    OLOG.fatal ('mess fatal');
End test_log;
/

select * from mjb_.

ID	PR_NAME	MESS	CREATED	LOG_ID	LOG_LEVEL 
111730	 	mess info 	 21/12/2015 1:38:43 PM	 	0  
111731	 	mess warn 	 21/12/2015 1:38:43 PM	 	1 
111732	 	mess error	 21/12/2015 1:38:43 PM	 	2 
111733	 	mess fatal	 21/12/2015 1:38:43 PM	 	3 

Pulse solutions.