Map ORACLE SP that returns a cursor

2

Please, I need your help to finish building an architecture. What I want to do is the following:

Create the ORACLE SP the CRUD, everything is easy, the main problem I have is that for the select I do something like:

CREATE OR REPLACE PROCEDURE BI.P_CAMARAS_ARQ
(
    I_COD_EMPRESA   IN  VARCHAR2,
    I_NUM_CUENTA    IN  NUMBER,
    O_SALDOS        OUT SYS_REFCURSOR
)
IS
BEGIN
    OPEN O_SALDOS FOR
    select cod_camara COD_CAMARA, descripcion DESCRIPCION from BI.ACH_CAMARA;
END P_CAMARAS_ARQ;

And at the time of importing the function from EF I do not see the generate complex type

Delete alert | Edit | Remove | Change of type Question You can not vote your own ticket 0

Well I understand that since the result data is a cursor, you must define some lines in APP.config , indicating certain parameters, I did it this way:

But in any case it does not allow me to generate the complex type based on the cursor columns.

Someone knows what else I have to do, I'm already suffering 2 days with this issue.

Note. I use VS2015, EF 6, Oracle 10g, EDMX.

Greetings and thanks in advance.

    
asked by RSillerico 16.03.2016 в 22:53
source

1 answer

1

You should validate this article

Entity Framework, LINQ and Model-First for the Oracle Database

Alli is mentioned

  

Note: If these stored procedures do not appear, make sure that you added them earlier in the OBE - INCREASE_SALARY_BY_10, UPDATE_AND_RETURN_SALARY and OUTPARAM in the HR schema under Procedures

Validate that you have added OUTPARAM surely in your case it will be called O_SALDOS

    
answered by 16.03.2016 в 23:05