Re: package variables

Use connection pooling and a database context to persist your session variables.

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adgsec02 .htm#1656

"R.B" <rich.bevan_at_bt.com> wrote in message news:b9qq9r$8ff$1_at_pheidippides.axion.bt.co.uk...
> While calling a procedure (which uses htp package) from a web browser, I
> observed that each procedure call creates a new session. As a result, the
> package variables, set by a procedure is not accessible to another
procedure
> of the same package.
>
> Is there any configuration setting on oracle http server which will force
> maintenance of a single session for all request coming from same ip
address
> ? or is there any other way in which we can instruct the server to
maintain
> session ?
>
> This is on Solaris 2.6 using the http server shipped with Oracle 8.1.7
>
> Thanks,
>
> Rich
>
>
Received on Tue May 27 2003 - 21:42:24 CDT