Reputation: 1
Store Procedure is
create or replace PROCEDURE GETCORPORATEACTION(
RECORD_DATE IN date,
prc out sys_refcursor
)
AS
BEGIN
OPEN prc FOR SELECT *
FROM HR.CORPORATEACTION
where RECORDDATE = RECORD_DATE;
END;
Calling SP using EF:
var CorporateActions = db.GETCORPORATEACTION(recordDate);
Error is Message = "ORA-06550: line 1, column 8:\nPLS-00306: wrong number or types of arguments in call to 'GETCORPORATEACTION'\nORA-06550: line 1, column 8:\nPL/SQL: Statement ignored"
Kindly anyone suggest me how to get rid out of this problem.Thanks in Advance.
Upvotes: 0
Views: 308
Reputation: 50077
There are a couple of problems:
The call should probably be something like
db.GETCORPORATEACTION(recordDate, CorporateActions);
Upvotes: 0