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
Begin
OLOG.info ('mess info ');
OLOG.warn ('mess warn ');
OLOG.error ('mess error');
OLOG.fatal ('mess fatal');
End test_log;
/
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