| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL and Oracle Webserver
>I have the problem of not knowing exactly the number of parameters which
>will be passed to the pl/sql procedure, so I can not specify the
>procedure header which is going to process the request. Take for example
I have the exact problem you specify, namely a table of checkboxes and I don't know how many of them will be choosed because i "write" them with a loop over a cursor of a table that the user can modify.
until now, the only partial workout I can see is to build a procedure that will accept a number of parameters surely abundant respect to what you reasonably expect.
it's an ugly method and it's even difficult to implement but for now it's all I can see.
I am trying just now to study something with passing arrays, but I still don't have it clear.
it would be nice to have the function to wait for *one* array variable, and then recurse through the array values with the equivalent of lbound to ubound...
someone else has a better picture?
 |
 |