甲骨文的BI Publisher失败如果设定参数，并试图查看数据

Question

当我尝试运行该SQL与人工值万事OK

SELECT * 
FROM epayment_application 
WHERE time_stamp 
BETWEEN 
TO_DATE('03/07/2017', 'dd/mm/yyyy') 
AND 
TO_DATE('05/07/2017', 'dd/mm/yyyy') 

当我更换参数值，并尝试查看数据

加载XML

SELECT * 
FROM epayment_application 
WHERE time_stamp 
BETWEEN 
TO_DATE(:DateFrom, 'dd/mm/yyyy') 
AND 
TO_DATE(:DateTo, 'dd/mm/yyyy') 

它给出无法加载XML错误。参数的类型是日期，格式也是dd/mm/yyyy。

我在做什么错？请帮忙。

Answer 1

像这样从BIP查询中删除TO_DATE。

SELECT * 
FROM epayment_application 
WHERE time_stamp 
BETWEEN 
:DateFrom 
AND 
:DateTo