Oracle 8.1.x - PL/SQL

From: Walter Dorninger <walter.dorninger_at_aon.at>
Date: Wed, 20 Feb 2002 23:37:14 +0100
Message-ID: <3c742515$0$20976$5039e797@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 Wed Feb 20 2002 - 16:37:14 CST

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