Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

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