Optional Parameters 1

[BJCooperIT]

This is a very basic question. I have a procedure with approx. 40 parameters. I want to call it but provide only the values that are absolutely necessary. I have tried this:

p_insert_push
(   return_code         => v_return_code,
    return_key          => v_return_key,
    in_action_code      => 'TRS',
    in_customer         => v_customer,
    in_dln              => v_dln,
    in_trans_date       => v_trans_date      );

but I receive a PLS-00306 error. Is my syntax incorrect or must I put it in a package to overload it? I have no idea what combinations of the parameters the client might want and neither do they.

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: www.EmuProductsPlus.com

 

[Dagon]

You can only bypass the parameters if they are optional i.e. a default has been provided.

 

[BJCooperIT]

Thanks, Dagon, I knew I had jumped this hurdle before, just couldn't remember how.