Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Required fields in called procedure

555294Jul 16 2007 — edited Jul 16 2007
Does anybody know whether there is a setting on a procedure to set all input parameters as required? And if there is then can it be turned off? I have a procedure B that is called from procedure A. Proc B requires several parameters to be passed, however not all of them are used for each individual call to Proc B from Proc A.

If I call Proc B from Proc A like this:

ProcB('', 'value2', '', 22, '', 87);

then it works fine. However if I attempt to pick and choose the parameters like below then I get a compilation error complaining about PLS-00306: Wrong numbe or types of arguments in call:

ProcB(vParam2 =>'value2', nParam4 => 22, nParam6 => 87);

Question is: does this mean it is not possible to use the 'pick and choose' => method? Or is the Procedure B set somehow that its input parameters are all required, and can this be changed?

Many thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2007
Added on Jul 16 2007
2 comments
511 views