Re: Passing PL/SQL tables with webserver

Tom Mettling <mettling_at_volpe.dot.gov> wrote: : Hi,  

: Does anyone out here know how to pass a PL/SQL table as a parameter from  

: one procedure to another using Webserver?  It doesn't work as an HTML
: hidden form field because it isn't text, and for the same reason, you
: can't put it in the URL.

You can though - if you pass multiple CGI-variables with the same name, this will be converted to a PL/SQL-table with the name of that variable.

For instance, take this piece of HTML:

<form action="foo" method="post">
<input type="hidden" name="bar" value="1">
<input type="hidden" name="bar" value="2">
<input type="hidden" name="bar" value="3">
<input type="submit">
</form>
 

and this piece of PL/SQL:

type my_array_type is table of varchar2(256) index by binary_integer;

procedure foo(bar in my_array_type) is
begin
  ...
  /* code is untested but should illustrate what I mean */ end;

This will work - the only case where it doesn't work is with an empty list. Therefore, if you do not know the size of the list in advance, always fill it with a dummy-element which you erase later on.

Hope this helps,

-- 
Jeroen Koops                         * *       EuroNet Internet BV
Special Projects Team              *     *     Herengracht 208 - 214
                                  *            1016 BS Amsterdam
E-mail: jeroen_at_nl.euro.net       *             Tel: +31 20 625 61 61