Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MOD_PLSQL and cookies - when available to the server?
"Andy Hardy" <junkmail@[127.0.0.1]> wrote in message news:SBNDEPBasieDFAUJ@[127.0.0.1]...
> In message <5I2dnQBkuYP3UeTenZ2dnUVZ_vudnZ2d_at_comcast.com> , Mark C. Stock > <mcstockX_at_Xenquery.com> writes
> > Correct. >
> > Thanks, I'll look into them. Once of my concerns is the way in which > mod_plsql handles the pooling of connections, etc. I'm not entirely sure > when it's safe to write to the global packages, etc. and knowing that the > current set of values refer to the current client and not to the previous > one... > > -- > Andy Hardy. PGP ID: 0xA62A4849
package to package calls (not URL calls) will have the same state, since its the same database session
think of it this way
Broswer submits URL to mod_plsql
--> package adds to HTTP stream (via htp.p) --> package calls package, same session, adds the HTTP stream --> package calls package, same session, adds the HTTP stream --> package calls package, same session, adds the HTTP stream --> end of database proessing; HTTP stream returned to and processed bybrowser
So, between the time the browswer submits the first URL and the stream is completed, all database calls will be the same session (and same transaction, unless you include transaction control statements)
++ mcs Received on Tue Nov 15 2005 - 13:05:23 CST