Function return CLOB .. I want to cache it!
Hello
I have function which return CLOB data. Function is called from WEB application ..about 1000 times in hour;
Function inside has 3 cursor from tables. After some scan & some heavy pl/sql manipulation function return clob Tables change very-very rare.
And result clob return change in time very very rare.
I know about DETERMINISTIC & RESULT CACHE. But this function is not deterministic. And i cannot use result cache due to return type is CLOB.
But i have vision - i can change it with some caching ..but i don't know how to do it