In my previous post I mentioned the problem with compiling a program unit that calls a database function with result cache.
Like I wrote in that post, the problem exists in the PL/SQL Client version.
There’s a patch available to update the PL/SQL client: Oracle Database Server Version 11.1.0.7 Patch 33.
This is a database patch, but it can also be applied to the middleware home.
After applying the patch, the program unit compiles…Problem solved!
So, go and start using Result cache!
Tags: forms 11g, Function result cache, Fusion Middleware 11G, Oracle Forms, PL/SQL
