Database Reference
In-Depth Information
Figure 7.9
Modify procedure.
Execute the procedure again by passing the class id 1000. his time, it should have no error
message. he result is shown in Figure 7.10.
If a user-deined procedure is no longer needed, you can delete the procedure with the DROP
PROCEDURE statement (Figure 7.11).
In the next section, you will learn a special kind of procedure that does not take input
parameters.
Figure 7.10
Execute procedure with class id 1000.
Figure 7.11
Drop procedure.
