Re: Which sessions hold state on which packages

I *think *Michael was looking for packages where the caller isn't necessarily "in" the package, but the caller's session has initialised some package state, and the caller's session hasn't ended yet. As you know, if user A has active state in package P, then if another user recompiles the package (maybe as a result of dependency-based invalidations) then user A will see the notorious “ORA-04068: existing state of packages has been discarded”.

NB there's a reference to this (which helped me remember the error number) at Eddie Awad's blog here:
http://awads.net/wp/2007/04/04/here-is-how-to-unpersist-your-persistent-plsql-package-data/, along with techniques for avoiding ORA-4068.

Regards Nigel

On 19 February 2010 17:43, Kurt Franke <Kurt-Franke_at_web.de> wrote:

> Mathias,
>
> I assume you don't do the select excatly at the time your very short
> package ist active.
> After it has finished it will no longer occure in v$code_object_in_use
>
>

--
http://www.freelists.org/webpage/oracle-l