Re: Maintaining state in web

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 11 Feb 2000 20:34:48 +0800
Message-ID: <38A401E8.6BDE@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 - 06:34:48 CST