Stored Procedure Overloading Error

[Joe San]

Guys,

I have a Stored Procedure declaration which is overloaded as below:

The package declaration block:

procedure proc_create_user ( 
   user_id             in    user_table.user_id%type
  ,language            in    user_table.language%type
  ,title               in    user_table.title%type
  ,first_name          in    user_table.first_name%type
  ,result_code         out   number
);

procedure proc_create_user ( 
   user_id             in    user_table.user_id%type
  ,language            in    user_table.language%type
  ,title               in    user_table.title%type
  ,first_name          in    user_table.first_name%type
  ,date_of_birth       in    user_table.date_of_birth%type
  ,gender              in    user_table.gender%type
  ,result_code         out   number
);

In the package body, I have the following call:

procedure proc_create_user ( 
   user_id             in    user_table.user_id%type
  ,language            in    user_table.language%type
  ,title               in    user_table.title%type
  ,first_name          in    user_table.first_name%type
  ,result_code         out   number
) is

begin
  result_code := proc_create_user(user_id => user_id, language => language, title => title,  -- LINE XX: 
                                first_name => first_name, null, null);
end proc_create_user;

Ant the overloaded version that has the logic defined....

procedure proc_create_user ( 
   user_id             in    user_table.user_id%type
  ,language            in    user_table.language%type
  ,title               in    user_table.title%type
  ,first_name          in    user_table.first_name%type
  ,date_of_birth       in    user_table.date_of_birth%type
  ,gender              in    user_table.gender%type  
  ,result_code         out   number
) is

begin

...
...
...
all the logic...
...
...
...
end proc_create_user;

When I tried to execute the statement, I got following error on LINE XX mentioned above:

PLS-00306: wrong number or types of arguments in call to PROC_CREATE_USER

What could be wrong here?

[Joe San]

I'm trying this in Oracle database.

[Joe San]

Managed to get rid of the problem. There were primarily two mistakes that I did:

(1) Stored Procedures as opposed to functions does not return any value
(2) The result code was missing in the parameter list to the overloaded stored proc