Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Resetting package state in other sessions
The goal is to reset package state in other sessions. I use packages for
support caching mechanism. Pakage state in all sessions must be cleared when
underlying information was changed by one session.
Regards
D.Rusakov
"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
news:3e29ae52_2_at_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 Sun Jan 19 2003 - 06:07:11 CST