Monday, December 11, 2023

How to write custom messages to the alert log file

exec sys.dbms_system.ksdwrt(2,'Your message here')
The first argument can be either

  • 1 -> Write to the trace file
  • 2 -> Write to the database alert log file
  • 3 -> Write to both of the above files
  • No comments:

    Post a Comment