SYS_REFCURSOR, Stored Procedures and the Entity Framework

SYS_REFCURSOR, Stored Procedures and the Entity Framework

Postby 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
warning 6005: The function 'GetProducts' has a parameter 'PRESULTSET' at parameter index 0 that has a data type 'REF CURSOR' which is not supported, the function was excluded.- ->



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.
rick.casey
 
Posts: 5
Joined: Fri 20 Jun 2008 16:55

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle