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.

Get Advanced Oracle PL/SQL Programming with Packages now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.