Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
- Posts: 1
- Joined: Tue 03 Aug 2010 02:32
Hello, I have the follow SP in Oracle:
Code: Select all
create or replace
PACKAGE BODY PKG_CADASTROS AS
PROCEDURE GETCOTACOESBYPERIODO(moeda IN NUMBER, dataInicial IN DATE, dataFinal IN DATE, CursorDadosSelect out SYS_REFCURSOR) IS
open CursorDadosSelect for
SELECT COD_MOEDA as CODIGOMOEDA, DT_COTACAO as DATACOTACAO, VLR_COTACAO as VALORCOTACAO
WHERE (COD_MOEDA = moeda) AND (DT_COTACAO >= datainicial) AND (DT_COTACAO <= datafinal)
ORDER BY DT_COTACAO DESC;
I did the import function and modify the XML File to use it, but when I use it, the follow error apear:
Cannot convert object of type 'Devart.Data.Oracle.OracleDate
- Devart Team
- Posts: 2919
- Joined: Mon 07 Jul 2008 13:16
I have made a test using both Devart Entity Developer (.edml model) and ADO.NET Entity Data Wizard (.edmx model).
In the first case I had just dragged the procedure from package to the model designer and everything worked OK.
In the second case I have performed the steps described in this blog post
and everything worked OK as well.
Could you please upgrade to the latest 5.70.152 build of dotConnect for Oracle?
Please let me know if the problem persists in this build.