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

For a single session, you can use a pl/sql table declared in a package.

For multiple sessions, you would have to write the data to an actual table.

Walter Dorninger <walter.dorninger_at_aon.at> wrote in message news:3c742515$0$20976$5039e797_at_newsreader01.highway.telekom.at...
> 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 Thu Feb 21 2002 - 02:42:07 CST