Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.x - PL/SQL - Caching ?!?
Would a global temporary table solve the problem?
Daniel Morgan
Walter Dorninger wrote:
> Hi,
>
> Im facing the problem that I need to cache some information in my PL/SQL
> Proc/Func. (when exiting the PL/SQL procedure/function the cache should
> still be there for the next call).
> Are there any methods for caching certain information using PL/SQL code
> (just to avoid expensive lookups between some independent PL/SQL calls).
>
> The only one I am aware of is to create a "cached" table in a temporary
> tablespace.
>
> Are there other solutions around?
>
> Walter Dorninger
> walter.dorninger_at_aon.at
Received on Wed Feb 20 2002 - 17:56:48 CST