Package Body Error

[timmbo]

Hi All,

I'm getting the following error when compiling my package.

PLS-00323: subprogram or cursor 'CREATE_ACH_REPORT' is declared in a package specification and must be defined in the package body

Can someone please tell me what I'm doing wrong. Following is my package code.

Package...

CREATE OR REPLACE package ACH_REPORT_PROCEDURES AS

  procedure CREATE_ACH_REPORT (NEW_seqNum IN number, NEW_companyID IN varchar2, NEW_shortName IN varchar2,
			       NEW_reportSelect IN varchar2, NEW_proccessDateFrom IN date, NEW_processDateTo IN date,
			       NEW_effectiveDateFrom IN date, NEW_effectiveDateTo IN date, NEW_minAmt IN numeric,
			       NEW_maxAmt IN numeric, NEW_recAcct IN varchar2, NEW_indivID IN varchar2);
				   
END ACH_REPORT_PROCEDURES;
/

Package Body...

CREATE OR REPLACE package body ACH_REPORT_PROCEDURES IS

  procedure CREATE_ACH_REPORT (NEW_seqNum IN NUMBER, NEW_companyID IN VARCHAR2, NEW_shortName IN VARCHAR2,
			       NEW_reportSelect IN VARCHAR2, NEW_proccessDateFrom IN DATE, NEW_processDateTo IN DATE,
			       NEW_effectiveDateFrom IN date, NEW_effectiveDateTo IN DATE, NEW_minAmt IN NUMBER,
			       NEW_maxAmt IN NUMBER, NEW_recAcct IN VARCHAR2, NEW_indivID IN VARCHAR2) IS
    BEGIN
      INSERT INTO SRS_ACH_ORIG_TEMP (seqNum, companyID, shortName, reportSelect, fromProcessDate, 
      					toProcessDate, fromEffectiveDate, toEffectiveDate, minAmount, 
      					maxAmount, receiverAccount, individualID)
        VALUES (NEW_seqNum, NEW_companyID, NEW_shortName, NEW_reportSelect, NEW_proccessDateFrom,
        	  NEW_processDateTo, NEW_effectiveDateFrom, NEW_effectiveDateTo, NEW_minAmt, NEW_maxAmt,
        	  NEW_recAcct, NEW_indivID);
      COMMIT;
    END;
				   
END ACH_REPORT_PROCEDURES;
/

TIA,
Tim

 

[lewisp]

CREATE OR REPLACE package ACH_REPORT_PROCEDURES AS

  procedure CREATE_ACH_REPORT (NEW_seqNum IN number, NEW_companyID IN varchar2, NEW_shortName IN varchar2,
                   NEW_reportSelect IN varchar2, NEW_proccessDateFrom IN date, NEW_processDateTo IN date,
                   NEW_effectiveDateFrom IN date, NEW_effectiveDateTo IN date, NEW_minAmt IN [COLOR=red]numeric[/color],
                   NEW_maxAmt IN [COLOR=red]numeric[/color], NEW_recAcct IN varchar2, NEW_indivID IN varchar2);
                   
END ACH_REPORT_PROCEDURES;
/

Change the keywords in red to NUMBER.

 

[timmbo]

Thanks much lewisp. That did it.