This appears to be a bit of a common issue but I can't find a solution that works for me.
I'm trying to return a Cursor from a Stored Procedure using Entity.
This is a basic example of what I'm trying to do. I've tried with a few different procedures and I get the same error each time.
PROCEDURE "RISK_GETALLCHANNELSNEW" (P_CUROSR OUT SYS_REFCURSOR)
OPEN P_CUROSR FOR
SELECT r.ChannelId, r.Name, CASE WHEN r.active = 1 THEN 'Active' ELSE 'InActive' END AS "Active", r.domain
FROM risk_channel r;
I have the app.config setup with the following columns and the Function Import finds all of the columns correctly.