FUNCTION function(p_levl_code VARCHAR2, p_coll_code VARCHAR2)
  RETURN VARCHAR2


IS
      v_institution   VARCHAR2 (3);
   BEGIN
      v_institution := NULL;

  IF (p_levl_code IN (g_cu, g_cg, g_cd))
  THEN
     v_institution := g_ccn;
  ELSIF (p_levl_code = g_gr)
  THEN
     IF (p_coll_code = g_kg)
     THEN
        v_institution := g_kel;
     ELSE
        v_institution := g_dvu;
     END IF;
  ELSIF (p_levl_code IN (g_ug, g_fn))
  THEN
     v_institution := g_dvu;
  END IF;

  RETURN v_institution;
   END;

<query id="GetInstitution" useConfig="jdbc">
      <sql>{ ? = call package.function (?,?)}</sql>
      <result element="Entries" rowName="Entry">
         <element column="v_institution>" name="Institution" xsdType="string"/>
      </result>
      <param name="Institution" sqlType="STRING" type="OUT"/>
      <param name="LevelCode" ordinal="2" sqlType="STRING"/>
      <param name="CollegeCode" ordinal="3" sqlType="STRING"/>
   </query>