Few development shops maintain parallel copies of an application’s source: one for debugging and one for production. But to remove them all, after system testing is done and before the application goes live, would compromise the ability of the debugging team to diagnose bugs that were first seen in the production environment. However these self-tests incur a run-time cost especially when they occur inside deeply nested loops. Such exceptions ideally should never be raised in the production environment. Such code raises an exception if an invariant on which the program design depends is violated. Now you can enable debugging or tracing functionality in the development environment and disable that functionality in the production application.Īpplications often contain self-checking code, to comply with good programming practices. In earlier releases, you had either to remove this code completely for production (hindering subsequent debugging) or to surround it with run-time IF tests (incurring a run-time cost in both program size and execution speed). You don’t want this code to run when the application runs in production. Thisįeature is very useful in the following cases:Īpplications often contain debugging or tracing code that is written specifically for testing purposes during the development cycle. When the PL/SQL program is submitted for compilation, the directivesĪre evaluated to select the intended parts of the program to be compiled. Applicationĭevelopers use conditional compilation by embedding directives in their PL/SQL Parts of a program, based on specified conditions, for compilation.
Oracle Database 10 g Release 2 introduces support for
In this overview section, you cover the following topics: 1. In Oracle Database 10 g, several enhancements are available You can hide an individual screenshot by clicking it. Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. (Caution: This action loads all screenshots simultaneously, so, depending on your Internet connection, may result in a slow response time.) Place the cursor over this icon to load and view all the screenshots for this tutorial. This tutorial covers the following topics: New PL/SQL features that are introduced in Oracle Database 10 g. Using Oracle Database 10 g PL/SQL New Features Purpose
0 kommentar(er)
