Re: Avoid Parameters being sent to PL/SQL Procedure.

From: Michael Rothwell <michael_rothwell_at_non-hp-usa-om46.om.hp.com>
Date: Fri, 02 Oct 1998 09:29:48 -0700
Message-ID: <3614FF7C.32D094CD@non-hp-usa-om46.om.hp.com>

Romain Voes wrote:
>
> I am writing an internet application which shows a variable number of screen
> elements (textboxes and checkboxes). On a first screen. When the user uses
> the submit button to send his entered values back, a second procedure has to
> get 'some' of these parameters in, but not all.
> In the current situation the program fails to run because the number of send
> parameters doesn't match with the number of expected parameters.
> Now if there were a fixed number of screen elements I could define dummy
> entries in the procedure description to intercept the unneeded param's but
> now I haven't got a clue how to work around this one. Could anyone put me
> back on the tracks?

If you never know the amount of elements ( table driven ) that will be on the screen, use pl-tables to pass the elements to the receiving procedure. That way you can use an unlimited amount of check boxes etc....

Michael. Received on Fri Oct 02 1998 - 11:29:48 CDT