Packages

PROCEDURE DBMS_SYSTEM.KSDIND

This procedure sets the level of indentation for output to the trace file and the alert log

The default level is 0

Output is indented using colons (Oracle 9.2)

For example the command

    EXECUTE dbms_system.ksdind (2);

causes the statement

    EXECUTE dbms_system.ksdind (1,'Output');

to write the following to the trace file

    ::Output

The statement

    EXECUTE dbms_system.ksdind (2,'Output');

writes the same output to the alert log.

This procedure does not work in trace files when SQL_TRACE = TRUE or event 10046 is enabled.