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