SYS_REFCURSOR, Stored Procedures and the Entity Framework

rick.casey · Post by **rick.casey** » Mon 23 Jun 2008 20:15

I have a procedure that I would like to return data through a cursor. When I try to import this using the EF Model, I get an error:

Code: Select all

This is my procedure in Oracle

Code: Select all

create or replace procedure "GetProducts" (pResultSet OUT SYS_REFCURSOR)
is
begin
OPEN pResultSet FOR SELECT * FROM PRODUCTS;
end;

I cannot find any documenation about SP support in OraDirect. Can you give me some direction?
Thanks
Rick.

Alexey.mdr · Post by **Alexey.mdr** » Wed 25 Jun 2008 08:11

Hello,

REF CURSOR type is not yet supported.
We are investigating this issue now.
Unfortunately, OraDirect .NET doesn't have any documentation for the using SP in EF now.
Generally, using SP in OraDirect .NET and pure EF for MS SQL server is the same. There are some links that might be helpful:
http://blogs.msdn.com/adonet/archive/20 ... pping.aspx

Regards,
Alexey.

AndreyR · Post by **AndreyR** » Mon 28 Jul 2008 13:51

REF CURSOR type support is implemented in both stored procedures and functions. Look forward to the next build.