+-+-+-+-+-+-+-+-+-+-+-
Drew Henegehold
+-+-+-+-+-+-+-+-+-+-+ 

Function created.

No errors.
========Testing print_test========
+-+-+-+-+-+-+-+-+-+
With input 4999, empls_with_salary should output 1
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.


EMPLS_WITH_SALARY                                                               
-----------------                                                               
                1                                                               

+-+-+-+-+-+-+-+-+-+
With input 1000, empls_with_salary should output 12
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.


EMPLS_WITH_SALARY                                                               
-----------------                                                               
               12                                                               


Warning: Procedure created with compilation errors.

Errors for PROCEDURE LIST_MANAGERS:

LINE/COL ERROR                                                                  
-------- -----------------------------------------------------------------      
9/9      PL/SQL: Statement ignored                                              
9/12     PLS-00204: function or pseudo-column 'COUNT' may be used inside a      
         SQL statement only                                                     
                                                                                
========Testing print_test========
+-+-+-+-+-+-+-+-+-+
With input job title Manager, list_managers output prompt With input job title Manager, list_managers output (Jonesmanaged by: King) (Blakemanaged by: King) (Raimimanaged by: King)
+-+-+-+-+-+-+-+-+-+
BEGIN list_managers('Manager'); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7: 
PLS-00905: object DJH133.LIST_MANAGERS is invalid 
ORA-06550: line 1, column 7: 
PL/SQL: Statement ignored 


+-+-+-+-+-+-+-+-+-+
With input job title Dreamer, list_managers output There are no employees with job title Dreamer
+-+-+-+-+-+-+-+-+-+
BEGIN list_managers('Dreamer'); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7: 
PLS-00905: object DJH133.LIST_MANAGERS is invalid 
ORA-06550: line 1, column 7: 
PL/SQL: Statement ignored 


SQL> exit