Oracle mod_plsql - parameter entry methods

From: Jeremy <>
Date: Wed, 20 Apr 2011 16:00:16 +0100
Message-ID: <MPG.2819055a7b21c29a9898e5_at_News.Individual.NET>

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
  if p_param1 is null then
    htp.p('hello world');
  end if;

And I want to invoke it from a browser:

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?

Received on Wed Apr 20 2011 - 10:00:16 CDT

Original text of this message