Re: Resetting state of PL/SQL package

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 18 Jan 2003 18:17:00 -0000
Message-ID: <3e29ae52_2@mk-nntp-1.news.uk.worldonline.com>

"Dmitry Rusakov" <r_d_a_at_chat.ru> wrote in message news:b0benk$27hc$1_at_storm.comstar.ru...
> Can I correctly reset pl/sql package state in other sessions from current
> session for support caching mechanisms?
>
>
>
> Sincerely
>
> D.Rusakov
>
>
>

If I understand the question correctly, I suspect you are barking up the wrong tree here. If you are trying to cache package information globally, this idea is a non-starter. By design, each session maintains its own 'package state' (i.e. memory area, e.g values of variables etc.) independently for the life of the session.

And a jolly good feature it is, too.

Regards,
Paul Received on Sat Jan 18 2003 - 12:17:00 CST