The idea of shift-left has become increasingly popular as teams face pressure to deliver software more frequently and with higher quality. Shift-left potentially speeds up development efficiency and helps reduce costs by detecting and addressing software defects as early as possible in the development cycle, ideally long before such defects get to production. “Fixing the […]
Category: There Is a Better Way
Executing the PL/SQL Procedure – Taking SQL Developer for a Drive
Executing the PL/SQL Procedure Right-click the UPDATE_EMPLOYEES procedure name in Figure 3-7. This should display the procedure-specific context menu, as shown in Figure 3-8. Notice the options available in relation to managing the PL/SQL procedure, such as: Figure 3-8. Executing PL/SQL in the containerized Oracle Database instance Clearly, this menu provides a lot of power. […]
Scale of Resilience Requirement 1: Capture All Errors and Exceptions – Applying the Scale of Resilience to the PL/SQL Code
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 […]
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 […]