October 1996
Intermediate to advanced
687 pages
16h 41m
English
Content preview from Advanced Oracle PL/SQL Programming with Packages
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 21. PLVlog and PLVtrc: Logging and Tracing
PL/Vision provides two packages to provide execution tracing and logging from within PL/SQL programs.
Use the PLVlog package to write information to a log.
Use the PLVtrc package to trace the execution of your PL/SQL programs.
Both of these packages are used by other PL/Vision packages, PLVlog in particular. For example, when you handle an exception with a PLVexc handler like rec_continue, it, in turn, calls PLVlog to log the error.