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

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Thu, 01 Oct 1998 18:36:10 GMT
Message-ID: <3614caf7.19351816@dcsun4.us.oracle.com>

On Thu, 1 Oct 1998 17:43:20 +0200, "Romain Voes" <Romain.Voes_at_VlaamsParlement.be> 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?

Have you tried defaulting the parameters to the procedure?

create procedure my_proc( p1 number default 0,

                          p2 number default null,
                          ...
                          pn varchar2 default null ) is

...

chris.
--

Christopher Beck
Oracle Corp.
clbeck_at_us.oracle.com Received on Thu Oct 01 1998 - 13:36:10 CDT