I have a stored procedure in Oracle and I try to call it from Crystal and I receive this error ODBC error:[MERANT][ODBC] [Oracle 8 driver] [Oracle 8 ]ORA-06550:line 1, column 8;PLS-00306: wrong number or types of arguments. I am not sure if the problem is with the stored procedure or with Crystal. Could someone help. Here is a sample of my stored procedure:
CREATE OR REPLACE PROCEDURE cashdly1(
p_Permit IN OUT VARCHAR2,
p_Receipt IN OUT VARCHAR2,
p_Method IN OUT VARCHAR2,
p_Notation IN OUT VARCHAR2,
p_Initials IN OUT VARCHAR2,
p_User_Id IN OUT VARCHAR2,
p_Amount IN OUT NUMBER) AS
CURSOR cur1 IS
SELECT DISTINCT Fee_Id.Number_Key, FEE_SUM.Receipt_No,
FEE_TRN.Method FEE_SUM.Initials,
FEE_SUM.User_Id, FEE_TRN.Amount
FROM Fee_Id, FEE_SUM, FEE_TRN, FEE_DETL,TRU_DETL
WHERE (Fee_Id.Trans_Id = FEE_SUM.Trans_Id)
AND (FEE_SUM.Trans_Id = FEE_DETL.Trans_Id)
AND (FEE_DETL.Trans_Id = FEE_TRN.Trans_Id)
AND ((FEE_TRN.Trans_Seq = TRU_DETL.Trans_Seq)
AND (FEE_TRN.Trans_Id = TRU_DETL.Trans_Id));
BEGIN
OPEN cur1;
LOOP
FETCH cur1 INTO p_Permit, p_Receipt, p_Method, p_Notation, p_Initials, p_User_Id,p_Amount;
EXIT WHEN cur1%NOTFOUND;
END LOOP;
CLOSE cur1;
END cashdly1;
thanks for any input.
