Default Parameter Values Not Working
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.