Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible.
I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Undocumented but appears to be an attempt to move the four named PL/SQL objects out of DBMS_SYSTEM.
Owned by SYS with no privileges granted
Prints the date stamp to the target file (alert log and/or trace file)
Flushes any pending output to the target alert log or trace file
Indents before the next write (ksdwrt) by printing that many colons (:) before the next write
dbms_log.ksdind(lvl IN BINARY_INTEGER);
Range of valid values from 0 to 30.
exec dbms_log.ksdwrt(3, 'Test Message');
Prints a message to the target file (alert log and/or trace file)
dbms_log.ksdwrt (dest IN BINARY_INTEGER, tst IN VARCHAR2);
1: Write to the standard trace file
2: Write to the alert log
3: Write to both files at once
dbms_system.ksdwrt(3, '-- Start Message --');
exec dbms_system.ksdwrt(3, 'Test Message');
exec dbms_system.ksdwrt( dbms_system.alert_file, '-- End Message --');