Re: Caching within packages..

From: Joachim Zobel <jzobel_at_my-dejanews.com>
Date: Wed, 10 Dec 2003 21:00:14 +0100
Message-ID: <pan.2003.12.10.20.00.03.363320@my-dejanews.com>

On Tue, 09 Dec 2003 22:43:37 +0000, NetComrade wrote:

> Either one of o'reilly books, or some other book, talked about how if
> you declare a function/procedure as part of a function, you can cache
> objects in an array for the life of a session, so u don't have to make
> a trip to a table again.. anyone remembers which one?

If you are using PL/SQL from inside the database its not a trip. And the database already does caching. You can tune it with hints, create table options and by using a keep buffer cache.

Joachim

-- 
Warnung: \" kann Augenkrebs verursachen.

Received on Wed Dec 10 2003 - 14:00:14 CST