Re: Oracle WEB Server Help

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1996/12/18
Message-ID: <32b8077e.2578978@dcsun4>#1/1

On 18 Dec 1996 14:13:07 +1100, hkusumo_at_socs.uts.EDU.AU (Haris Kusumo) wrote:

>Hi,
>
>I just wondering if you could tell me what htp.formHidden do?
>I can use it to store data temporaryly and retrive it later on?
>does it function like normal HTML form?, how do I retrive the data I don't
>think submit button will ever attach to that form?
>

htp.formHidden( cname, cvalue ) simply outputs the following:

When the user submits the form, your pl/sql routine that is the action of the form will recieve "YourValue" in the input parameter named "YourFieldName". For example, if you have one procedure that:

...

   htp.formOpen( 'myprocedure' );
   htp.formHidden( 'x', 5 );
   htp.formHidden( 'y', 10);
   htp.formSubmit;
   htp.formClose;

...

You will have a procedure such as:

create or replace procedure myprocedure( x in varchar2, y in varchar2 ) as
begin

htp.p( 'x = ' || x || htf.br || 'y = ' || y ); end;

X and Y in myprocedure will always be 5 and 10 in this example. You can use the hidden fields to maintain a state of sorts between calls.

>Can you also tell me how to repaginate the output on Oracle Web Server?
>i.e. I have PL/SQL query that will return 100 rows, and I'd like to display
> 20 records per page and at the end I'd like to put next and prev button
> to go to next or prev page.
>If I use cursor to retrive the data it's ok for user to click on next page
>because I can fetch 20 recordas at one time, but what if the user press
>prev button, how do I go back and fetch prev 20 records?
>

goto http://govt.us.oracle.com/ and follow the link to downloadable utilities. An example of how to do this is found in the OWA Extensions.

>I appreciated if you could e-mail me the reply soon,because I need to get the
>web page up and running before mid january.
>
>
>you can e-mail me at hkusumo_at_socs.uts.edu.au
>
>Thanks in advance
>- Haris -

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com

http://govt.us.oracle.com

Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Wed Dec 18 1996 - 00:00:00 CST