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.