Re: package variables

On Tue, 13 May 2003 13:53:18 +0100, "R.B" <rich.bevan_at_bt.com> wrote:

>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
>

Package variables are not shared across sessions. If you need them sharred across sessions put them in a table (easy is it not?)

Solaris 2.6 is desupported

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue May 13 2003 - 12:58:06 CDT