SQL> @ 328lect05-2 Procedure created. No errors. ============ TESTING loopy ============ calling loopy(5) should see: ====== BURP! followed by 0-4, GLIP! followed by 13-16, all department names and locations, empl nums and names of the four Sales employees, a message that King has a salary 1000 times 5, and finally a note that reached end with NO exceptions: ============ BURP! 0 BURP! 1 BURP! 2 BURP! 3 BURP! 4 GLIP! 13 GLIP! 14 GLIP! 15 GLIP! 16 Accounting is in New York Management is in New York Operations is in Boston Research is in Dallas Sales is in Chicago 7499: Michaels 7521: Ward 7654: Martin 7844: Turner Look! King has salary that is 1000 times 5 PROC REACHED ITS NATURAL END (NO exceptions were raised) PL/SQL procedure successfully completed. ============ calling loopy(2) should see: ====== BURP! followed by 0-1, GLIP! followed by 13-16, all department names and locations, empl nums and names of the four Sales employees, a message that NO employee has a salary 1000 times 2, (and NEVER REACH the final dbms_output.put_line because of the no_data_found exception) ============ BURP! 0 BURP! 1 GLIP! 13 GLIP! 14 GLIP! 15 GLIP! 16 Accounting is in New York Management is in New York Operations is in Boston Research is in Dallas Sales is in Chicago 7499: Michaels 7521: Ward 7654: Martin 7844: Turner MOO, NO employees had salary 1000 times 2 PL/SQL procedure successfully completed. ============ calling loopy(1.25) should see: ====== BURP! followed by 0-1, GLIP! followed by 13-16, all department names and locations, empl nums and names of the four Sales employees, a message that MORE THAN ONE employee has a salary 1000 times 1.25, (and NEVER REACH the final dbms_output.put_line because of the too_many_rows exception) ============ BURP! 0 BURP! 1 GLIP! 13 GLIP! 14 GLIP! 15 GLIP! 16 Accounting is in New York Management is in New York Operations is in Boston Research is in Dallas Sales is in Chicago 7499: Michaels 7521: Ward 7654: Martin 7844: Turner MORE than one employee had salary 1000 times 1.25 PL/SQL procedure successfully completed. Procedure created. No errors. ============ TESTING reverse_play ============ testing reverse_play(): should see i from 2 to 5, j from 5 to 2, and that is all: ============ i: 2 i: 3 i: 4 i: 5 j: 5 j: 4 j: 3 j: 2 PL/SQL procedure successfully completed. SQL> spool off