Re: passing URLs as parameter values in OWA 3.0

From: Richard Willemsen <rwillems_at_xs4all.nl>
Date: 1998/06/11
Message-ID: <357f9312.8516496@192.168.0.1>#1/1

Hi Alexander,

On Wed, 10 Jun 1998 20:09:45 +0200, Alexander Day <ajd_at_sqlsystems.dk> wrote:

>How, in the name of God, do you pass URLS (with their own set of
>parameters) as parameters in a URL call?!?!?
>
>Confusing?
>
>e.g.
>
>.../my_dad/owa/pack_name.proc_name?parm1=pack_name2.proc_name2?parm21=blah&parm22=ghgh
>
>where parm21 and parm22 are PARAMETERs for proc_name2 ?
>
>the ORACLE WEb server (OWS 3.0) keeps giving me error messages saying,
>"wrong number of parameters passed to proc_name -> as it interprets
>proc_name2's parameters as proc_name's.
>
>There must be a way around this - surely?
>
>Heinously frustrated,
>
>Alexander Day
>mailto:ajd_at_sqlsystems.dk
>

Try something like:

../my_data/owa/pack_name.proc_name?url=pack_name2.proc_name2&pname=parm21&pvalue=blah&pname=parm22&pvalue=ghgh

source code of pack_name.proc_name:

....
....
procedure proc_name(
  url in varchar2,
  pname in owa_util.ident_arr,
  pvalue in owa_util.ident_arr
) is
begin

process url, pname and pvalue end; .... ....

The result is that in proc_name you have:

- a varchar2 variable which contains the URL
- a pname PL/SQL table of parameter names
- a pvalue PL/SQL table of parameter values

After this you can construct the new url which will be: pack_name2.proc_name?parm21=blah&parm22=ghgh

grtnx,
Richard

Real programmers don't comment their code. It was hard to write, it should be hard to understand.

Richard Willemsen
http://www.xs4all.nl/~rwillems/ Received on Thu Jun 11 1998 - 00:00:00 CDT