This procedure writes messages to a trace file or to the alert log
The procedure takes the following arguments:
Argument Name | Type | In/Out | Default? |
DEST | BINARY_INTEGER | IN | |
TST | VARCHAR2 | IN |
The DEST argument takes the values
Value | Description |
1 | Trace File |
2 | Alert Log |
3 | Both Trace File and Alert Log |
To write a message to the trace file use
EXECUTE dbms_system.ksdwrt (1, 'Output written to trace file');
To write a message to the alert log use
EXECUTE dbms_system.ksdwrt (2, 'Output written to alert log');
To write a message to both the trace file and the alert log use
EXECUTE dbms_system.ksdwrt (3, 'Output written to both trace file and alert log');