SQL> /* Prompts */: Oracle 11g function result cache.

From: Quseful #10: Oracle11g function result cache (Steven Feuerstein)
Namely, whenever anyone in that database instance calls the function, Oracle first checks to see if anyone has already called the function with the same input values. If so, then the cached return value is returned without running the function body. If the inputs are not found, then the function is executed, the inputs and return data is stored in the cache, and then the data is sent back to the user. Oracle 11g function result cache.


PACKAGE BODY emplu IS
   FUNCTION onerow(employee_id_in IN employees.employee_id%TYPE)
      RETURN employees%ROWTYPE 
      RESULT CACHE RELIES_ON(employees) 
   IS
      onerow_rec employees%ROWTYPE;
   BEGIN
      SELECT *
        INTO onerow_rec
        FROM employees
       WHERE employee_id = employee_id_in;
      RETURN onerow_rec;
   END onerow;
END emplu;
/