Scale of Resilience Requirement 1: Capture All Errors and Exceptions Referring to Table 4-1, the score for this requirement is 0. The basic problem in relation to error and exception handling in Example 4-2 is that there isn’t any! In other words, if an error or exception occurs, it will result in an immediate termination […]
Category: Updating the User Password
The Changes for Exception Handling – Applying the Scale of Resilience to the PL/SQL Code
The Changes for Exception Handling Notice in Example 4-3 the addition of some screen output in the form of the call: DBMS_OUTPUT.PUT_LINE(‘Success – we got here 1!’); Normally only developers will see this screen output, but it can also become visible to other users. As you’ll see, output from DBMS_OUTPUT.PUT_LINE is very useful for providing […]