DBMS_SYSTEM.KSDIND Procedure

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

Argument Name Type In/Out Default?
LVL BINARY_INTEGER IN

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.