Knowing what is going on in an executing PL/SQL block can provide valuable information. Setting client_identifier, module, and action from within a PL/SQL block can help track what each session is doing. In the DBMS_SESSION package, there are supporting procedures and functions for this.
Within the DBMS_UTILITY package are procedures and functions that can identify the call stack in case of an unexpected exception. Even ...
Get Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON 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.
Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.
Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.
Start your free trial Become a member now