Re: [Q] pl/sql cusror state using Oracle web agent, web server & database server

Quentin North wrote:
> I am trying to use Oracle web server 1.0, Oracle web agent and Oracle
> Server 7.3.3 to simply return a list of items from a table in groups of
> ten as a web page allowing the user to click "next ten" when required.

There is also a nice PL/SQL package that comes with the OWS 1.0 that does this very thing. Try connecting to your admin server URL with the following URL:
http://www.server.org:nnnn/owa_dba/owa/browse.intro (where nnnn is the port used for your admin server) which allows you to step through any table 100 (hard coded value - blech!) records at a time. The code is in $ORACLE_HOME/ows/admin/browse.sql (and browseu.sql for non-DBA users) and basically uses hidden form elements to retain the information on retrieved rows from page to page.

cheers,
kevin reardon Received on Mon Feb 02 1998 - 00:00:00 CST