Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.x - PL/SQL - Caching ?!?

Re: Oracle 8.1.x - PL/SQL - Caching ?!?

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Wed, 20 Feb 2002 23:56:48 GMT
Message-ID: <3C7437D2.78369F3@ci.seattle.wa.us>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US