如何使用实体框架在 oracle 包内调用存储过程? [英] How to call a Stored Procedure inside an oracle package with Entity Framework?
本文介绍了如何使用实体框架在 oracle 包内调用存储过程?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在 oracle 11g 中有一个包如下:
I have a package in oracle 11g as follow:
CREATE OR REPLACE PACKAGE "HRS.PKG_TRAINING_SP" as
TYPE T_CURSOR IS REF CURSOR;
procedure GETPERSONNELTRAINIGLIST(
personnel_Id_in in string,
base_date_in in string,
is_current_in in number,
lst OUT T_CURSOR );
end;
如何使用实体框架(代码优先)执行上述程序包(GETPERSONNELTRAINIGLIST
)?
How can I execute above procedure package (GETPERSONNELTRAINIGLIST
) with Entity Framework (code-first)?
注意:我正在使用 Entity Framwork 6.0(代码优先)和 devar EF Provider
for Oracle.
Note: I am using Entity Framwork 6.0 (code-first) and devart EF Provider
for Oracle.
更新:我正在使用以下代码:
var param1 = new OracleParameter("personnel_Id_in", OracleDbType.VarChar, "c5eb5589-8fee-47b6-85ad-261a0307cc16", ParameterDirection.Input);
var param2 = new OracleParameter("base_date_in", OracleDbType.VarChar, "1112", ParameterDirection.Input);
var param3 = new OracleParameter("is_current_in", OracleDbType.Number, 1, ParameterDirection.Input);
var ATests =
db.Database.SqlQuery<ATest>(
"BEGIN PKG_TRAINING_SP.GETPERSONNELTRAINIGLIST(:personnel_Id_in, :base_date_in, :is_current_in); end;",
param1, param2, param3).ToList();
但出现以下错误:
{"ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GETPERSONNELTRAINIGLIST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"}
推荐答案
请按照以下方式重写您的代码:
Please rewrite your code in the following way:
var param1 = new OracleParameter("personnel_Id_in", OracleDbType.VarChar, "c5eb5589-8fee-47b6-85ad-261a0307cc16", ParameterDirection.Input);
var param2 = new OracleParameter("base_date_in", OracleDbType.VarChar, "1112", ParameterDirection.Input);
var param3 = new OracleParameter("is_current_in", OracleDbType.Number, 1, ParameterDirection.Input);
var param4 = new OracleParameter("result", OracleDbType.Cursor, ParameterDirection.Output);
var ATests =
db.Database.SqlQuery<ATest>(
"BEGIN PKG_TRAINING_SP.GETPERSONNELTRAINIGLIST(:personnel_Id_in, :base_date_in, :is_current_in, :result); end;",
param1, param2, param3, param4).ToList();
此外,我们已经在我们的论坛 http://forums.devart.com/viewtopic.php?t=29019
Also, we have contacted you at our forum http://forums.devart.com/viewtopic.php?t=29019
这篇关于如何使用实体框架在 oracle 包内调用存储过程?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文