Executing PLSQL Code

Executing PL/SQL Code

TOAD enables you to develop and run code without having to leave one environment and go to another (as you would using an editor and SQL*Plus, for example). Code can easily be run by clicking the Run button or pressing the F11 key. Figure 4.36 illustrates the parameter screen as TOAD noticed that this procedure has input variables. The TEMPERATURE_CONVERSION procedure calls two functions. After these parameters are set, use the '(...)' button or Ctrl+F9 to change any of the variables ( brings up this same interface). Figure 4.37 shows the completion of the procedure. Notice the output in the DBMS_OUTPUT tab.

Figure 4.36. The Set Parameters input screen.

Figure 4.37. Executing code.

F11 = Run