Page 1 of 1
How to execute a procedure in oracle package with entity framework (code-first)?
Posted: Sun 23 Feb 2014 13:15
by amyrh
I have a package in oracle 11g as follow:
Code: Select all
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;
How can I execute above procedure package (GETPERSONNELTRAINIGLIST) and next step, store returned Results in IEnumerable object with Entity Framework?
Note: I am using Entity Framwork 6.0 (code-first) and devart EF Provider for Oracle.
Re: How to execute a procedure in oracle package with entity framework (code-first)?
Posted: Tue 25 Feb 2014 09:15
by MariiaI
We have sent you a small test project to the e-mail address you have provided in your forum profile. Please check that the letter is not blocked by your mail filter.
Please tell us if this helps.
Re: How to execute a procedure in oracle package with entity framework (code-first)?
Posted: Sat 03 May 2014 07:43
by samuel12
Hello,
May I also ask for a copy of the code you sent?
Thanks a lot!
Re: How to execute a procedure in oracle package with entity framework (code-first)?
Posted: Mon 05 May 2014 07:22
by MariiaI
samuel12 wrote:Hello,
May I also ask for a copy of the code you sent?
Thanks a lot!
We have sent you a small test project to the e-mail address you have provided in your forum profile. Please check that the letter is not blocked by your mail filter.
Please also refer
here.
Re: How to execute a procedure in oracle package with entity framework (code-first)?
Posted: Fri 30 Jan 2015 21:16
by cmorante
Dear MariiaI, someone other recipe for this?, I don't like that the parameter names are burned. Additionally, both, the package name and procedure name are burned in the source code. Any other suggestion?
Re: How to execute a procedure in oracle package with entity framework (code-first)?
Posted: Mon 02 Feb 2015 11:50
by MariiaI
Please describe the issue in more details, for example:
- the version of EF you are working with;
- the version of dotConnect for Oracle (or other Devart product you are using);
- what do you mean about "the package name and procedure name are burned in the source code".
If possible,
send us a test project and describe the steps we should perform to reproduce this issue, so that we are able to investigate it in more details.