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. […]
Category: Executing the PL/SQL Procedure
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 […]