Re: Oracle Packages and Shared/Pooled connections [newbie question]

Paul Boothroyd wrote:

> Could somebody please confirm my understanding of "declared" variables
> within a package, i.e. a package "instance" is stateful (retains
> values), until it is dropped from the Oracle PL/SQL execution block.
>
> (I am a little unsure whether, on PL/SQL integrated with the Database
> Server is part of the System Global Area of memory, or is distinct.)
>
> Cheers, Paul
>
> Paul Boothroyd wrote:
> > (Sorry I have not had time to check this out myself yet.)
> >
> > From the notes I have regarding PL/SQL packages, they state that
> > variables and constants declared in both the Specification (Interface)
> > and Body (Implementation) are defined for the lifetime of a user session.
> >
> > I believe this has some serious implications regarding the usage of
> > connection pools from many types of client, PHP; Java; etc.
> >
> > Could somebody please forward me URL's or an outline of the problems
> > encountered ?
> >
> > Cheers (TIA), Paul
> >

Part of the SGA.

Daniel Morgan Received on Fri Jan 24 2003 - 14:25:10 CST