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

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
>

I don't think a connection pool will actually use the same session for different request origins. I.e. if I used application screen A, and you did as well, that would be two sessions. Maybe using the same userid, but two sessions.

If not, I would not want the connection pool mechanism.

Just my 2c, Frank Received on Wed Jan 22 2003 - 15:23:50 CST