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;
Cannot convert object of type 'Devart.Data.Oracle.OracleDate