Re: Passing data from one page to another

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 15 Jun 1998 22:58:01 GMT
Message-ID: <3586a605.2624323@192.86.155.100>

A copy of this was sent to bkw_at_iquest.net (Brian Wooldridge) (if that email address didn't require changing) On 15 Jun 1998 22:10:34 GMT, you wrote:

>Hopefully this isn't too simple. I am using OAS 3.0 with the pl/sql cartridge
>to generate some 'dynamic' html pages based on user input and database query.
>
>I will have a series of 3-5 pages to gather all the data I need, with different
>data being asked on each page. I want to pass the data from page one to page
>two to page three, etc.
>
>I know I can use the POST method in my forms to send the data to the server
>between pages, but how do I read it into variables on the next page using
>pl/sql?
>

Hidden fields. If form1 calls form2 calls form3 and form1 gets A, B and form2 get C, D and form3 gets E, F you might have procedures:

create procedure form1
create procedure form2( a in varchar2, b in varchar2 ) create procedure form3( a in varchar2, b in varchar2, c in varchar2, d in varchar2 )

and the forms themselvs might look like:

Form 1 ------------- <form action=form2 method=post> <input type=text name=a> <input type=text name=b> <input type=submit> </form>
Form 2 ------------- <form action=form3 method=post> <input type=hidden name=a value="Value from Previous Form"> <input type=hidden name=b valou="Value from Previous Form"> <input type=text name=c> <input type=text name=d> <input type=submit> </form>

So, procedure form1 would generate the first form, form2 would get A and B and store them as hidden fields in the second form, which it generates and so on...

>tia,
>
> _________________________________
> / /_ _ __ /
> / __ \ | /| / / Brian Wooldridge /
> / /_/ / |/ |/ / bkw_at_iquest.net /
>/_.___/|__/|__/__________________/
>

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jun 15 1998 - 17:58:01 CDT