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!

Default Parameter Values Not Working

Christine1111Sep 12 2006 — edited Sep 12 2006
Can anyone tell me what I'm missing........When I call the procedure it keeps telling me "invalid number of arguments", but my default value should cover that, especially because I'm using the named notation........

Here's my call:

Run_Analysis(date_in =>SYSDATE,
result_out =>l_result);

Here is the declaration of the procedure I'm calling:

CREATE OR REPLACE PROCEDURE Run_Analysis (
date_in IN DATE,
option_list_in IN VARCHAR2 := 'options',
result_out OUT NUMBER ) IS

Any help is greatly appreciated.....thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2006
Added on Sep 12 2006
8 comments
576 views