Another Alternative to the Command-Line Use of Docker Docker Desktop also provides some pretty decent container management features. In Figure 2-16 you see the container listing, which comprises the Oracle Database container. In Figure 2-16, you can also look at the container image by clicking the Images option, as shown in Figure 2-17. As the […]
Category: Getting Started with Docker
Fixing the Pesky PL/SQL Error – Taking SQL Developer for a Drive
Fixing the Pesky PL/SQL Error In the previous chapter, we encountered the error shown in Example 3-1 during the PL/SQL run. Example 3-1. An error is born! Errorreport–ORA–01722: invalid number ORA–06512: at line 15 01722. 00000 –“invalid number” *Cause:Thespecified number wasinvalid.*Action:Specify a validnumber. Let’s look a little more closely at Example 3-1. Notice that there’s an error on line 15. I need to locate that line […]
Executing the PL/SQL Procedure 2 – Taking SQL Developer for a Drive
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 […]
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 […]