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 […]
Posts
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 […]
Installing a PL/SQL Procedure in the Database – Taking SQL Developer for a Drive
Installing a PL/SQL Procedure in the Database I’ve made a small change to the PL/SQL code in the form of adding a PROCEDURE name, as shown in Example 3-2. Example 3-2. Completing the declaration of the PL/SQL procedure CREATE OR REPLACE PROCEDURE update_employees IS CURSOR c1 is SELECT ename, empno, sal FROM emp ORDER BY sal DESC; — start with highest paid employee my_ename VARCHAR2(10);my_empno NUMBER(4);my_sal NUMBER(7,2); BEGINOPEN c1; FOR i IN 1..5 LOOPFETCH c1 INTO my_ename, my_empno, my_sal; EXIT WHEN c1%NOTFOUND; /* in case the number requested*//* is more than […]
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 […]
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 […]
Running the Updated PL/SQL – Applying the Scale of Resilience to the PL/SQL Code
Running the Updated PL/SQL Before running the new version of the PL/SQL procedure, I need to replace the old one. To do this, I drop the existing version, as shown in Figure 4-1. Just right-click the procedure name and use the dialog you saw back in Figure 3-8. Technically, the CREATE OR REPLACE will of […]