Tag: Function result cache

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 Patch 33. This is a database […]

Result cache… a very cool feature in the 11g database. If you don’t know it, this is a must read: Pl/SQL function result cache in 11g But also watch out with it in Forms 11g. It seems there’s a bug. When compiling a program unit that calls a function with result cache in forms, you’ll […]