Devart Forums

Posted: **Tue 03 Aug 2010 02:36**

Hello, I have the follow SP in Oracle:

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

Posted: **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.