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.