SQL> @ 328lect05-2

Procedure created.

No errors.
======
TESTING procedure 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 for the four Sales employees
...a message that King has a salary of 1000 times 5
and FINALLY a note that we reached the 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 for the four Sales employees
and then a message that NO employee has salary 1000 time 2

(and NEVER REACH the last note, because WAS an 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                                                                    

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 for the four Sales employees
and then a message that MORE THAN ONE employee has salary 1000 time 1.25

(and NEVER REACH the last note, because WAS an 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.

SQL> spool off