How to execute a procedure in oracle package with entity framework (code-first)?

[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.

[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.

[samuel12]

Hello,

May I also ask for a copy of the code you sent?

Thanks a lot!

[MariiaI]

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.

[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?

[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.