CREATE OR REPLACE FUNCTION clobblobtest (TMP_MID VARCHAR2)
   RETURN VARCHAR
IS
   missed_text    VARCHAR2 (1000) := '';
   v_time_stamp   DATE;
   v_end_time     DATE;

   CURSOR c1 (c_time_stamp IN DATE, c_mid IN VARCHAR2)
   IS
      SELECT mn.TEXT
        FROM msgnotes mn
       WHERE mn.mid = c_mid AND mn.create_date >= c_time_stamp;

   CURSOR c2 (
      c_time_stamp   IN DATE,
      c_mid          IN VARCHAR2,
      c_end_time     IN DATE)
   IS
      SELECT mn.TEXT
        FROM msgnotes mn
       WHERE     mn.mid = c_mid
             AND mn.create_date >= c_time_stamp
             AND mn.create_date <= c_end_time;
BEGIN
   IF ('1' = 'INWARD RETURN')
   THEN
      SELECT bbi
        INTO missed_text
        FROM mtf1000
       WHERE mid = TMP_mid;
   ELSIF '1' = 'QPH Missed'
   THEN
      SELECT MAX (nj.update_date)
        INTO v_time_stamp
        FROM newjournal nj
       WHERE nj.mid = TMP_mid AND nj.status = 'CTOVRQ';

      FOR i IN c1 (v_time_stamp, TMP_mid)
      LOOP
         missed_text := missed_text || ' ' || i.text;
      END LOOP;
   ELSIF ('Rejected' = 'Rejected' OR 'REJECTED' = 'REJECTED')
   THEN
      IF ('TERMINATED' IN ('TERMINATED'))
      THEN
         SELECT MIN (nj.update_date), MAX (nj.ENDDATE)
           INTO v_time_stamp, v_end_time
           FROM newjournal nj
          WHERE     nj.mid = TMP_mid
                AND nj.actionid2 = '16'
                AND nj.actionid1 IS NULL;

         FOR i IN c2 (v_time_stamp, TMP_mid, v_end_time)
         LOOP
            missed_text := missed_text || ' ' || i.text;
         END LOOP;
      ELSE
         SELECT MAX (nj.update_date)
           INTO v_time_stamp
           FROM newjournal nj
          WHERE nj.mid = TMP_mid AND nj.status = 'UNSETLED';

         FOR i IN c1 (v_time_stamp, TMP_mid)
         LOOP
            missed_text := missed_text || ' ' || i.text;
         END LOOP;
      END IF;
   ELSE
      missed_text := NULL;
   END IF;

   RETURN (missed_text);
END;

SELECT MIN (nj.update_date), MAX (nj.ENDDATE)
           INTO v_time_stamp, v_end_time
           FROM newjournal nj
          WHERE     nj.mid = TMP_mid
                AND nj.actionid2 = '16'
                AND nj.actionid1 IS NULL;

         FOR i IN c2 (v_time_stamp, TMP_mid, v_end_time)
         LOOP
            missed_text := missed_text || ' ' || i.text;
         END LOOP;

select 
  t.id,
  stored_function_1 (t.col_1) result_1,
  t.emp_name,
  stored_function_2 (t.col_5, t.col_8) result_5
from your_table t
where ...