Hi this relates to all versions of OHS - though we are currently using
the version that comes with 10gR2 on the companion CD.

Say we have a pl/sql proc:

create or replace procedure myproc (p_param1 in varchar2 default null)
is
begin
if p_param1 is null then
htp.p('hello world');
else
htp.p(p_param1);
end if;
end;
/

And I want to invoke it from a browser:

http://myserver.mydomain.com/dad_nam...param1=goodbye

In the above URL we are specifying the parameter names to the plsql
procedure explicitly.

I have a vague recollection of an alternative URL composition which
would mean that the parameter names need not be specified - but the
recollection is indeed so vague and now I don't know if I imagined it or
maybe was thinking of a different language.

Has anyone got a clue what I am asking for?

--
jeremy

Jeremy wrote:

Perhaps are you talking about "Flexible Parameter Passing"?

http://vanbortel.blogspot.com/2006/0...parameter.html

But the parameter names must still be specified...

In article <4daefa67$0$6824$5fc30a8 (AT) news (DOT) tiscali.it>, yossarian99
@operamail.com says...
That's what I was looking for - thanks!

The parameter names do not have to be named in the URL - you can call
them what you want and they get passed to a generically named
array....the documentation says this:

procedure [proc_name]
(name_array IN [array_type],
value_array IN [array_type]);

Thanks for your help.

--
jeremy