COLUMN_NAME |
DATA_TYPE |
NULLABLE |
DATA_DEFAULT |
COLUMN_ID |
COMMENTS |
ID |
NUMBER |
No |
null |
1 |
Identification to keep sequence of records in log |
SEVERITY |
NUMBER |
Yes |
null |
2 |
Severity level 1 - fatal, 2 - error, 3 - warning, 4 - info, 5 - debug |
PROCEDURE_NAME |
VARCHAR2(200 BYTE) |
Yes |
null |
3 |
Name of procedure |
MSG |
VARCHAR2(4000 BYTE) |
Yes |
null |
4 |
Content of message |
LOG_TIME |
TIMESTAMP(6) |
Yes |
systimestamp
|
5 |
Datetime of logged event |
LOG_DATE |
VARCHAR2(8 BYTE) |
Yes |
to_char(sysdate, 'yyyymmdd')
|
6 |
Date of logged event. It is redundant information, but usefull while mantenece. |