Paging thru data - stored procedure and/or sql example needed

From: nichols <nichols_at_blarg.net>
Date: Wed, 17 Mar 1999 16:27:49 -0800
Message-ID: <36F04885.3E1C603C@blarg.net>

Does anyone have an example of how to retrieve the next 20(and so on) rows from an Oracle table via a select statement and/or Oracle stored procedure. This is needed so the user can page thru a lot of records on

an HTML web page.

I have example that gets all the records but only displays so many at a time. The problem with this one is that it retrieves all the rows from the Oracle server and sends them to the web server. The asp script loops the records and only sends the 20 or so records to the client's web browser. That's alot of data going across network.

Note: Microsft IIS web server, ASP, Visual Basic (used for the middle tier) and Oracle stored procedures are used for the application we are building.

Thanks for your help,

Frankie Received on Wed Mar 17 1999 - 18:27:49 CST