SqlSugar Oracle调用存储过程 PLS-00306: 调用 'SP_STUDENT' 时参数个数或类型错误 返回
Create or replace procedure sp_student
(
--参数
p_stuName in Nvarchar2, --类型
p_cursor out Sys_Refcursor --返回结果集
)
is
begin
open p_cursor for
Select a.id,a.name,b.name As ScholName,c.name As subName,c.print
From student a
Inner Join school b On a.sch_id=b.id
Inner Join subject c On c.studentid=a.id
Where 1=1 And a.name=p_stuName;
end;
List<SugarParameter> pars = new List<SugarParameter>();
pars.Add(new SugarParameter("@p_stuName", "小杰"));
pars.Add(new SugarParameter("@p_cursor", "", true));
var dt4 = db.Ado.UseStoredProcedure().GetDataTable("sp_student", pars);

在Oracle中测试存储过程是Ok的,代码SqlSugar调用存储过程一直报错