PL/SQL (MOSC)

MOSC Banner

Function return CLOB .. I want to cache it!

edited Apr 24, 2020 1:47AM in PL/SQL (MOSC) 6 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center