Packages
PROCEDURE DBMS_SYSTEM.KSDWRT
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
| |
| 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');
|