Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
- Posts: 5
- Joined: Fri 20 Jun 2008 16:55
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:
This is my procedure in Oracle
Code: Select all
create or replace procedure "GetProducts" (pResultSet OUT SYS_REFCURSOR)
OPEN pResultSet FOR SELECT * FROM PRODUCTS;
I cannot find any documenation about SP support in OraDirect. Can you give me some direction?
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
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
- Devart Team
- Posts: 2919
- Joined: Mon 07 Jul 2008 13:16
REF CURSOR type support is implemented in both stored procedures and functions. Look forward to the next build.