| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Undocumented but appears to be an attempt to move the four named PL/SQL objects out of DBMS_SYSTEM. |
| AUTHID |
DEFINER |
| Dependencies |
| DBMS_DBFS_CONTENT |
DBMS_SYSTEM |
|
|
| Documented |
No |
| First Available |
12.1 |
| Security Model |
Owned by SYS with EXECUTE granted to the
DBFS_ROLE role. |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtlog.plb |
| Subprograms |
|
| |
| KSDDDT |
| Prints the date stamp to the target file (alert log and/or trace file) |
dbms_log.ksdddt; |
exec dbms_log.ksdddt;
PL/SQL procedure successfully completed. |
| |
| KSDFLS |
| Flushes any pending output to the target alert log or trace file |
dbms_log.ksdfls; |
exec dbms_log.ksdfls;
PL/SQL procedure successfully completed. |
| |
| KSDIND |
| 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.ksdind(5);
PL/SQL procedure successfully completed.
exec dbms_log.ksdwrt(3, 'Test Message');
PL/SQL procedure successfully completed. |
| |
| KSDWRT |
| 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 |
exec dbms_system.ksdwrt(3, '-- Start Message --');
PL/SQL procedure successfully completed.
exec dbms_system.ksdwrt(3, 'Test Message');
PL/SQL procedure successfully completed.
exec dbms_system.ksdwrt(dbms_system.alert_file, '-- End Message --');
PL/SQL procedure successfully completed. |