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');