Help on PLS-00323 please !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Help on PLS-00323 please !

  1. #1
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809

    Help on PLS-00323 please !

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    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.

    Code:
    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>
    this space intentionally left blank

  3. #3
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    Darn, I knew it was stupid... Thanks gandolf989.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width