Cannot convert object of type 'Devart.Data.Oracle.OracleDate

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
evertonfoz
Posts: 1
Joined: Tue 03 Aug 2010 02:32

Cannot convert object of type 'Devart.Data.Oracle.OracleDate

Post by evertonfoz » Tue 03 Aug 2010 02:36

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
  BEGIN
    open CursorDadosSelect for
      SELECT COD_MOEDA as CODIGOMOEDA, DT_COTACAO as DATACOTACAO, VLR_COTACAO as VALORCOTACAO
      FROM TB_COTACAO
      WHERE (COD_MOEDA = moeda) AND (DT_COTACAO >= datainicial) AND (DT_COTACAO <= datafinal)
      ORDER BY DT_COTACAO DESC;
  END GETCOTACOESBYPERIODO;

END PKG_CADASTROS;
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

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 12 Aug 2010 14:10

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.

Post Reply