Help on PLS-00323 please !

[pipo]

Hi all,

I am probably doing something extremely stupid, however I cannot understand why I keep on getting this PLS-00323 error with this (simplified) code :


create or replace package pkg is
procedure proc1 (a in varchar2);
procedure proc2 (a in varchar2);
end pkg;
/

create or replace package body pkg is

procedure proc1 (a in varchar2) is
begin
dbms_output.put_line(a);
end proc1;

procedure proc2 (b in varchar2) is
begin
proc1(b);
end proc2;

end pkg;
/

sho error

Any help will be welcome !

Thanks,

Kewin

[gandolf989]

Apparently the signiture on the procedures/functions must be exactly the same between the package and the package body. You have proc2 with the parameter a in the header and b in the body.

SQL> create or replace package pkg is
  2  procedure proc1 (a in varchar2);
  3  procedure proc2 (a in varchar2);
  4  end pkg;
  5  /

Package created.

SQL>
SQL> show errors
No errors.
SQL>
SQL> create or replace package body pkg is
  2
  3  procedure proc1 (a in varchar2) is
  4  begin
  5  dbms_output.put_line(a);
  6  end proc1;
  7
  8  procedure proc2 (a in varchar2) is
  9  begin
 10  proc1(a);
 11  end proc2;
 12
 13  end pkg;
 14  /

Package body created.

SQL>
SQL> show errors
No errors.
SQL>

[pipo]

Darn, I knew it was stupid... Thanks gandolf989.