Variable number of arguments in PL/SQL stored procedure

Question

Can a procedure PL/SQL take a variable number of arguments?

In my case, the procedure is called by the submit button of a form, and the form has variable number of inputs.

Answer 1

You don't mention it, but are you using mod_plsql?

If so, you should read about flexible parameter passing.

In short, prefix your procedure name with an exclamation mark in your browser and define your procedure with a name_array and value_array.

Answer 2

Sort of. You can give the procedure parameter default values:

CREATE PROCEDURE myproc( p_value_a NUMBER DEFAULT 1, 
                         p_value_b NUMBER DEFAULT 2 ) AS
    ...

which you could call like this:

myproc( 999 );

or like this:

myproc (p_value_b => 11 );