Hello,
New to forum and I need some help as soon as possible.

I have a procedure that I have written. When running the procedure in Oracle it works great gets the expected results, but when I try to call the procedure in Crystal 10.5 I get the error message PLS-00306: wrong number or types of arguments.

The issue seems to be with a parameter that is defined as a number. When I comment out that parameter or when i run another procedure without a "Number" parameter then I have no issues. Here is my procedure:

DROP TABLE XAGTLST_GT CASCADE CONSTRAINTS;

CREATE GLOBAL TEMPORARY TABLE XAGTLST_GT
(
ANGPNO VARCHAR2(8 BYTE) NOT NULL,
ANGPLC VARCHAR2(8 BYTE) NOT NULL,
ANBNTP VARCHAR2(2 BYTE) NOT NULL,
ANEFTO NUMBER NOT NULL
)
ON COMMIT DELETE ROWS
NOCACHE;



CREATE OR REPLACE PACKAGE XAGTLST_PKG
AS TYPE XAGTLST_CSR IS REF CURSOR
RETURN XAGTLST_GT%ROWTYPE;
END XAGTLST_PKG;


CREATE OR REPLACE PROCEDURE XAGTLST_PROC
(XAGTLST_Cursor IN OUT XAGTLST_PKG.XAGTLST_CSR,
p_AgentID in umr_qlstage.AGENCM_TB.ANAGNT% type ,
p_EffectiveThruDt in umr_qlstage.AGENCM_TB.ANEFTO% type,
p_SourceDB in umr_qlstage.AGENCM_TB.SOURCE_DB% type
)
AS
BEGIN
OPEN XAGTLST_Cursor FOR
SELECT ANGPNO,
ANGPLC,
ANBNTP,
ANEFTO
FROM UMR_QLSTAGE.AGENCM_TB
WHERE ANAGNT = p_AgentID
AND ANEFTO = p_EffectiveThruDt
AND substr(SOURCE_DB,1,2) = p_SourceDB;
END XAGTLST_PROC ;