We're all into building modular reusable code, but like many situations, often accomplishing the mission brings up other issues. How can application code be "registered" within the database so that commonly-used PL/SQL code and SQL statements can be differentiated by how they're used within different program modules? The built-in packages DBMS_APPLICATION_INFO, DBMS_DEBUG, and DBMS_SESSION have several ways to make applications easier to debug, tune, improve, understand, track, and administer. With advantages like that, what's not to love? This presentation will provide SQL and PL/SQL code examples and templates as a reference point for use back at work.
Become a member of ODTUG to gain access to more than 12,500 files in our technical database.
- Not a member? Click through to the topic of interest to browse a list of available presentations.
- Already a member? Log-in here to access the full database
Click here to see the Full Techincal Resource Database