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

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
>
Received on Fri Jan 24 2003 - 10:14:00 CST