Miscellany

create or replace package pz_package is

  g_max_maandsal number default 5000;
  e_max_extends_bereik exception;
  pragma exception_init(e_max_extends_bereik, -1631);
  
  cursor c_med
  is
  select med.mnr,
      med.naam,
      med.maandsal
      from medewerkers med
  order by med.gbdatum;
  
  function naam_medewerker
    (p_mnr in afdelingen.mnr%type,
      p_locatie in afdelingen.mnr%type default 'LEERDAM',
      p_hoofd in afdelingen.mnr%type default null);
  end pz_package;