Re: Maintaining state in web

I haven't looked into webDB at all yet, so I don't understand how this works.

If your connection to the database
is maintained, why are your package
variables being reset ?

Is it the web server that maintains
its single connection, forgets who you are and therefore drops your context, closes all your cursors and explicitly resets
all packages as soon as it stops talking to you ?

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Connor McDonald wrote in message <38A401E8.6BDE_at_yahoo.com>...
>Jonathan Lewis wrote:
>>
>> Are you maintaining a session
>> connection to the database
>> for the duration, or do you connect
>> and disconnect between each call ?
>>
>> --
>>
>> Jonathan Lewis
>> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>>
>> Connor McDonald wrote in message <38A2B155.1D6A_at_yahoo.com>...
>> >I'm selecting from a very expensive cursor and presenting 'n' rows on a
>> >web page.
>> >
>> >When I want to present the NEXT 'n' rows is it possible to simply resume
>> >fetching from the same cursor ? If so, I'm wondering how to do so..
>> >
>> >Cheers
>> >
>> >--
>> >===========================================
>> >Connor McDonald
>> >There are 3,434,679 oracle websites around the world.
>> >Now there is one more... http://www.oracledba.co.uk
>
>Connection retained but all package variables (and hence my cursor) etc
>reset...Basically using WebDB as a listener and using the standard
>underlying OAS packages (htp, htf etc etc)...
>
>Cheers
>Connor
>
>--
>===========================================
>Connor McDonald
>There are 3,434,679 oracle websites around the world.
>Now there is one more... http://www.oracledba.co.uk
Received on Fri Feb 11 2000 - 14:37:50 CST